| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Threaded Mode
