coliervile
Well-known Member
- Joined
- May 19, 2006
- Messages
- 724
Hello everyone-
I'm trying to sum column E based on Today's date. I have academic classes that start and end on dates through out the year and have different number of students in each class. The Start Date is in column C, End Date in column D and Class Size is in column E. The information starts in row 2 and ends in row 101.
I tried the following formula and it returned a zero, which isn't correct.
=SUMIFS($E$2:$E$101,$C$2:$C$101,">="&$H$1,$D$2:$D$101,"<="&$H$1)
I want to know how many students I have based on the date in cell H1.
What am I missing?
Thanks for your help,
Charlie
I'm trying to sum column E based on Today's date. I have academic classes that start and end on dates through out the year and have different number of students in each class. The Start Date is in column C, End Date in column D and Class Size is in column E. The information starts in row 2 and ends in row 101.
I tried the following formula and it returned a zero, which isn't correct.
=SUMIFS($E$2:$E$101,$C$2:$C$101,">="&$H$1,$D$2:$D$101,"<="&$H$1)
I want to know how many students I have based on the date in cell H1.
What am I missing?
Thanks for your help,
Charlie
Last edited: