sum between dates

[Ian Bartlett]

I am trying to sum numbers from sheet one which has dates in column a range
name date07, and column B range name hours07.

I am trying to gather this info on sheet two where

in column a I have a date in cell a5 another date in cell a6
what I am trying to get is a formula
sumif(date07,>=a5 &<=a6) that's the logic but of course it doesn't compute.

Thanks for any help

Bart

 

[Ian Bartlett]

oops
sumif(date07,>=a5 &<=a6),(hours07)

 

[Guest]

Hi Ian,
Please be a little specific and start with an example so I reply you back.

Daoud Fakhry

 

[Guest]

Try this:

=SUMIF(date07,"<="&A6,hours07)-SUMIF(date07,"<"&A5,hours07)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Ian Bartlett]

Ron

Thanks for your reply, I didn't copy the file home so I can't check til
tonight, looks good, will advise.

Again thanks
Bart

 

[Don Guillett]

If I understand what you want dates in B
count
=sumproduct((b2:b22>=a5)*(b2:b22<=a6))
sum C
=sumproduct((b2:b22>=a5)*(b2:b22<=a6)*c2:c22)