| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Expanded sumproduct
I have this and it works fine:
=SUMPRODUCT(($A$14:$A$30002=$B$1)*($B$14:B$30002=$ A$3)*($C$14:$C$30002=$C$2)*($D$14:$D$30002)) And this works fine if I want more than one value from column A: =SUMPRODUCT(SUMIF(A14:A30002,{"A","B","C"},D14:D30 002)) But how do I include the the column B and C columns and criteria into the 2nd formula. Thank you, Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanded Vlookup | Excel Discussion (Misc queries) | |||
| Can the function window be expanded? | Excel Worksheet Functions | |||
| Can worksheet space be expanded | Excel Discussion (Misc queries) | |||
| SUMPRODUCT formula expanded from original | Excel Discussion (Misc queries) | |||
| Tab Key Expanded Cell Movement | Excel Discussion (Misc queries) | |||
Threaded Mode
