I need a formula to sum column b if column a is between two dates

[Guest]

I have an excel spreadsheet with employees time off. I need a formula that
will add column b if column a is betwee two dates. For example: if column a
is between 9/22/04 and 9/21/05 then add column b. I have tried all different
formluas but can't get this to work.

 

[Guest]

=SUMPRODUCT(--(A2:A100>DATEVALUE("9/22/04")),--(A2:A100<DATEVALUE("9/21/05")),B2:B100)

check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
for details on the sumproduct function

 

[Ron Rosenfeld]

I have an excel spreadsheet with employees time off. I need a formula that
will add column b if column a is betwee two dates. For example: if column a
is between 9/22/04 and 9/21/05 then add column b. I have tried all different
formluas but can't get this to work.

=SUMIF(A:A,">="&DATE(2004,9,22),B:B) - SUMIF(A:A,">"&DATE(2004,9,21),B:B)

You may find it more convenient to but the Dates into cells, in which case
merely substitute the cell reference for the DATE function in the above.


--ron