| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct IF Q
I wish to Sumproduct Col B x D (from rows 5 to 10) but only if the
Value in Col M5:10 = Cars So I could have a scenario of ColB5 x ColD5 + ColB7 x ColD7 + ColB8 x ColD8 + ColB10 x ColD10 = As M6 & M9 were not = Cars, then I ignored them from my Calculation Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct Help | Excel Discussion (Misc queries) | |||
| Can this be done using Sumproduct? | Excel Worksheet Functions | |||
| Like Sumproduct, But Different | Excel Worksheet Functions | |||
| Sumproduct Help | Excel Worksheet Functions | |||
Threaded Mode
