F
Frannie21
When using the SUMIF function it allows a criteria from one colomn. How do
you right that to be between two dates.
you right that to be between two dates.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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.
where X2 <= Y2, calculates a total for dates that are between X2 and Y2
inclusive.
J
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 "--"
=SUMPRODUCT(--(A1:A100>DATE(2005,1,1)), --(A1:A100<TODAY()), B1:B100)
See
http://www.mcgimpsey.com/excel/doubleneg
for an explanation of the "--"
B
Bernard Liengme
Correction to link:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
J
JE McGimpsey
Thanks for the correction - the other will also work if you include the
..html (my browser adds it if necessary).
..html (my browser adds it if necessary).