View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian Bartlett Ian Bartlett is offline
external usenet poster
 
Posts: 22
Default 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