| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif between dates (quarters)
"island hopper" wrote...
I'm trying to sum hours spent in each quarter. Am using xl 03 and a 7/12 date format. Tried 3/13*<7/1 for 2nd quarter criteria, but it doesn't work. Presumably 3/13 is a typo and should have been 3/31. If so, =SUMIF(Dates,"3/31/2007",Values)-SUMIF(Dates,"6/30/2007",Values) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting dates into their respective fiscal quarters | New Users to Excel | |||
| How do I get dates recognised as annual quarters? | New Users to Excel | |||
| working out quarters (three-month periods) between two dates | Excel Worksheet Functions | |||
| Formatting of dates into quarters | Excel Discussion (Misc queries) | |||
| How do I Turning Dates into Quarters | Excel Worksheet Functions | |||
![Harlan Grove[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
