Sum Column Based On Date

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
 
Last edited:

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
I should have made it more clear on my expected results....
I want to know how many students I have in the classes that are currently in progress based on the date in cell H1.

Thanks
Charlie
 
Upvote 0
Shouldn't your < and > be the other way around (dates below in dd/mm/yyy)

Excel Workbook
CDEFGHI
114/02/20159
201/02/201505/06/20156
302/03/201505/06/20157
401/01/201504/05/20153
Sheet2
 
Upvote 0
Thank you Mark858 for your suggestion and solution. That's what I get for working on a project for to long...

Charlie
 
Upvote 0

Forum statistics

Threads
1,202,959
Messages
6,052,797
Members
444,602
Latest member
Cookaa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top