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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SumProduct If?
One way:
=SUMPRODUCT(--(A1:A1000="Jan"),E1:E1000,F1:F1000) In article . com, Steve wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SumProduct If?
Thank you!!
On Sep 11, 9:13 am, JE McGimpsey wrote: One way: =SUMPRODUCT(--(A1:A1000="Jan"),E1:E1000,F1:F1000) In article . com, Steve wrote: 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!- Hide quoted text - - Show quoted text - |
Reply |
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) |