| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple criteria for sumproduct
I am trying to keep a running sum of customer order amounts for a given year
to compare TY vs. LY using the following formula: =SUMPRODUCT(--('Wholesale Orders'!G2:G2000<=DATE(2008,12,31)),--('Wholesale Orders'!G2:G2000=DATE(2008,1,1)),--('Wholesale Orders'!C2:C2000=A2))--('Wholesale Orders'!F2:F2000) With the G column as the date range, C column as the customer name, and F column as the $amount. i do not get an error, but the formula result is an erroneous value. Do the arrays in sumproduct need to fall in a specific sequence? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumProduct With Multiple criteria | Excel Worksheet Functions | |||
| Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
| multiple criteria in if or sumproduct | Excel Worksheet Functions | |||
| Using Sumproduct with multiple Criteria | Excel Worksheet Functions | |||
| sumproduct using multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
