| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct for YTD with text filter
I am trying to sum a customers sales for a year to date value so I can
compare it with the year to date sales for the previous years. The formula is: =SUMPRODUCT(--('Wholesale Orders'!G2:G2008<=TODAY()),--('Wholesale Orders'!G2:G2008DATE(2007,12,31)),--('Wholesale Orders'!C2:C2000)=A5,--('Wholesale Orders'!F2:F2008)) It works perfectly until it calculates array #3, cell #A5 of the current worksheet is a text value (customer name). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter or sumproduct (Question for Gord Dibben) | Excel Discussion (Misc queries) | |||
| filter in text | Excel Discussion (Misc queries) | |||
| Filter and SumProduct | Excel Worksheet Functions | |||
| Filter text in a column by its Indent, to remove certain text | Excel Discussion (Misc queries) | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
