According to your situation, I can change the input method. I can enter the time, meals and people in a separate table, and then use the countifs function to count the number of people (as shown in the figure). Because the meals are only breakfast, lunch and dinner, which can be designed in a row, it is also possible to add supper. If the person is not fixed, you can copy the person column (column C) to a blank location, and then select Data-Delete. Then copy the copied data to the statistician column (column E starts from cell E2), and the recipe of the meal can be automatically calculated by drop-down. The advantage of this method is worry-free, so you don't have to worry after entering the original data.