| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal - Based on DATE
Hi,
My formula below retunrs "0" because this year, I think "12" refers to December 2008. The formula below was to produce December 2007. Please edit the formula below so it can produce December 2007 and/or December of ANY year that I will select in the future. =SUMPRODUCT(--(TEXT('Processing'!$J$2:$J1995,"m")="12"),--('Processing'!$J$2:$J1995<"")) Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhide column based on subtotal level open. | Excel Discussion (Misc queries) | |||
| Subtotal based discounts | Excel Discussion (Misc queries) | |||
| How to calculate shipping costs based on subtotal | Excel Worksheet Functions | |||
| subtotal based on two conditions | Excel Discussion (Misc queries) | |||
| I need to subtotal based on an if | Excel Worksheet Functions | |||
Threaded Mode
