| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding a range of dates to total
I have a sheet with many dates and I want to search for date ranges in
monthly intervals then total all cells next to the date. for example: =SUMIF(H:H,DATE(2006,1,1):(2006,1,31),I:I) for the month of january--however this formula is incorrect. Does anyone know a correct one to use? Thanks in advance, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How do I count in a range of dates? | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| count date occurances in range of dates... | Excel Worksheet Functions | |||
| Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
Threaded Mode
