Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
in the 3rd array of my sumproduct formula, i'd like to have it look for more
then one option. what is the correct way to write this forumla??? =SUMPRODUCT(--(COLUMN1=A1),--(COLUMN2=A2),--('BW COLUMN3=A3 or A4 or A5),(COLUMN4)) tia!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SumProduct | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Help with SUMPRODUCT | Excel Discussion (Misc queries) | |||
SUMPRODUCT ??? | Excel Discussion (Misc queries) |