sum between dates
 

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

sum between dates
 

oops
sumif(date07,=a5 &<=a6),(hours07)
"Ian Bartlett" wrote in message
news:Cbomi.119444$1i1.82204@pd7urf3no...
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

sum between dates
 

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

Daoud Fakhry

"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

sum between dates
 

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

sum between dates
 

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

"Ron Coderre" wrote in message
...
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

sum between dates
 

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)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ian Bartlett" wrote in message
news:Cbomi.119444$1i1.82204@pd7urf3no...
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