SumIf based on a date

[billyshears]

I am trying to do a sumif/s between two dates.

A1 is = 11/21/2016
A2 = 11/25/2016


Column C1:C20 = to different dates

Column D1:D20 = to amounts of money

I want B1 to be equal to a sum of all the money equal to or between the dates in cell A1 and A2

I cant seem to get this to work

 

[chicagocomputerclasses]

=sumifs(d1:d20,c1:c20,">="&a1,c1:c20,"<="&a2)

 

[CyrusTheVirus]

The difference between Chicago's formula and mine is that his includes the 21st and 25th whereas mind does not. I'm not sure what you wanted, but one of the formulas should suffice what you're trying to do.

B1:

=SUMIFS($D$1:$D$20,$C$1:$C$20,">"&$A$1,$C$1:$C$20,"<"&$A$2)

11/21/2016	2299	11/11/2016	1596
11/25/2016		11/12/2016	171
		11/13/2016	1724
		11/14/2016	373
		11/15/2016	127
		11/16/2016	96
		11/17/2016	1853
		11/18/2016	127
		11/19/2016	414
		11/20/2016	1787
		11/21/2016	1931
		11/22/2016	1909	YES
		11/23/2016	190	YES
		11/24/2016	200	YES
		11/25/2016	177
		11/26/2016	1512
		11/27/2016	1170
		11/28/2016	1733
		11/29/2016	589
		11/30/2016	935

<tbody>
</tbody>