| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate a SUMIF if criteria is between 2 date ranges
I want to create a SUMIF function but I only want it to return the value of
items within and inclusive of 2 dates. e.g the sum of column C if column A has dates between 01/07/06 and 30/09/06 inclusive. Similarly I want to create a COUNTA function for the same criteria. I am using Microsoft Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for a formula to calculate date intervals | Excel Worksheet Functions | |||
| Calculate a date or key a date on condition | Excel Discussion (Misc queries) | |||
| How do I retrieve a date in a column of dates which > my criteria | Excel Worksheet Functions | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| dsum with date criteria | Excel Worksheet Functions | |||
Threaded Mode
