# sumif with dates

#### Kraner

##### New Member
I have a date someone donated and the amount the donated. I'd like to sum up how much was donated each month.

Thanks!

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
found this and it works!
" =SUMIFS(\$b\$1:\$b\$5,\$A\$1:\$A\$5,">"&c3,\$A\$1:\$A\$5,"<="&c4)

where b1:b5 is sum range,
a1:a5 is criteria range dates
c1 & c2 hurdle dates "

Replies
2
Views
2K
Replies
4
Views
204
Replies
3
Views
327
Replies
1
Views
1K
Replies
4
Views
276

1,196,073
Messages
6,013,273
Members
441,759
Latest member
ab_

### 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