Hi all!
I have class dates in column B. I have number of students in column C. In cell G1 I have the month & year (Aug-2005, Sep-2005, etc). I'm trying to sum all of the students by month beginning in cell G2.
I'm headed down the path of SUMIF((month(B:B)&year(B:B),(MONTH(U1)&YEAR(U1)),C:C) but that formula is not working. Any ideas to point me down the right path? Thanks!
Brian
Bookmarks