SUMIF function - criteria of between two dates. How?

[Guest]

When using the SUMIF function it allows a criteria from one colomn. How do
you right that to be between two dates.

 

[Aladin Akyurek]

=SUMIF(DateRange,">="&X2,SumRange)-SUMIF(DateRange,">"&Y2,SumRange)

where X2 <= Y2, calculates a total for dates that are between X2 and Y2
inclusive.

 

[JE McGimpsey]

one way:

=SUMPRODUCT(--(A1:A100>DATE(2005,1,1)), --(A1:A100<TODAY()), B1:B100)

See

http://www.mcgimpsey.com/excel/doubleneg

for an explanation of the "--"

 

[Bernard Liengme]

Correction to link:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

 

[JE McGimpsey]

Thanks for the correction - the other will also work if you include the
..html (my browser adds it if necessary).