Try this:

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

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

XL2002, WinXP


"Ian Bartlett" wrote:

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