| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT column criteria
Can anyone tell me if an entire column can be used as criteria in a
SUMPRODUCT formula? I tried: =-SUMPRODUCT(--('PS Sales'!$K:$K='Jan 09'!I$1),--('PS Sales'!$F:$F='Jan 09'!$A18),'PS Sales'!$H:$H) but got a #NUM! error. Using =-SUMPRODUCT(--('PS Sales'!$K$1:$K$60000='Jan 09'!I$1),--('PS Sales'!$F$1:$F$60000='Jan 09'!$A18),'PS Sales'!$H$1:$H$60000) works fine, but typing the row numbers every time is a huge waste of time! Thanks! -- GD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT - Count Various criteria in same column (exclude other) | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| sumproduct with multiple criteria in single column | Excel Discussion (Misc queries) | |||
| sumproduct 2 columns based on criteria in 3rd column | Excel Discussion (Misc queries) | |||
| Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
Threaded Mode
