| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif function with a date range condition statement
I'm trying to sum the numbers in one column that fall within specified date
ranges listed in another column i.e. how many products were produced during a given quarter throughout a fiscal year. The formula I've created looks something like: =SUMIF(L7:L226,"=AND(<9/30/2008,01/01/2009)",M7:M226) or basically (SUMIF(dates column,date range condition, numbers column to sum)) I suspect that the problem lies within the formatting for the date range condition, but I haven't been able to find the proper usage for using a date range within a condition statement. Anyone out there know how to make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| condition sumif commands based on date range? | Excel Discussion (Misc queries) | |||
| SUMIF function with text color condition | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| Date Format Inside of a SUMIF Statement | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
