# Sum Column Based On Date

#### coliervile

##### Well-known Member
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?

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

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

Thank you Mark858 for your suggestion and solution. That's what I get for working on a project for to long...

Charlie

Replies
1
Views
124
Replies
3
Views
187
Replies
7
Views
331
Replies
20
Views
672
Replies
12
Views
197

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.

### Which adblocker are you using?

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

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