Forum Discussion
Solved
Expanding Meals Count on each date
Hi All I have a set of data here down below in table 1. (Attached the excel too) I want to prepare Table 2 based on the date in table 1. ie., I want to expand the data from Table 1 based on fro...
See the attached version for a solution using formulas.
I also modified the formulas in Table 1 slightly.
With everyone's permission, if I may add a simple formula in addition to the elegant solution proposed by Mr. Hans Vogelaar (@Hans Vogelaar).
=SUMIF($D$3:$D$21,$M3,$H$3:$H$21)+SUMIF($F$3:$F$21,$M3,$H$3:$H$21)
File is inserted.
If the simple suggested solution helps you, I'll be happy, if not please just ignore it :).
Thank you for your understanding and patience
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)