In excel, how to use the function to calculate the number of times someone eats breakfast, lunch and dinner every month?

1, insert the auxiliary column first, mark the consumption time at 8 o'clock and 12 with the hour function, and then count with the conditional counting function.

2. This function can also be used to calculate the number of breakfast meals for Wang Yunhua = SUMPRODUCT ((month (A2: A 1000) = 2) * (hour (A2: a1000 =1) * (hour (A2:). = 12)*(B2:B 1000= "Wang Yunhua"). This formula means that breakfast is before 9 o'clock, and Chinese food is from 1 1 to 12.