Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT has never let me down BUT...
Here's the deal: I know SUMPRODUCT is capable of comparing multiple values
against an array by using {}'s like this: Cell A1: SUMPRODUCT((ARRAY={Option1,Option2,Option3})*ARRAY 2SUM) BUT can the criteria range be made to reference a cell value??? Something like this: Cell A1: SUMPRODUCT((ARRAY={A2})*ARRAY2SUM) Cell A2: "Option1,Option2,Option3" This would be soooo helpful if possible. Thanks in advance. -- John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |