Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SumProduct If?
Hi all. I have a column of Months in Col A (Jan-Dec). Conceptually,
I need to look down column A, and for every instance of "Jan", multiply Col E by Col F, and then sum all the resulst. So essentially, its a sum if. Bt instead of summing a single column, its summing the multiplaication of 2 columns. I know I can have a helper column. But this example is WAY oversilmplfied. I would need about 12 helper columns, which I would like to avoid if possible. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
sumproduct or...? | Excel Worksheet Functions | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) |