Rayne
asked on
Sum the products of columns Excel
Hello All,
I want to add products of three columns in a sumif expression type or similar way. Like as long as the event is the same, sum up the TOTAL (products of A*B*C)
Like….if you look at the worksheet here…this “sumif” or something similar will do like this below:
a(A*B*C)+ a(A*B*C) +a(A*B*C)
b(A*B*C)
c(A*B*C)+c(A*B*C)+c(A*B*C)
Thank you
R
sum-the-products-along-columns.xlsx
I want to add products of three columns in a sumif expression type or similar way. Like as long as the event is the same, sum up the TOTAL (products of A*B*C)
Like….if you look at the worksheet here…this “sumif” or something similar will do like this below:
a(A*B*C)+ a(A*B*C) +a(A*B*C)
b(A*B*C)
c(A*B*C)+c(A*B*C)+c(A*B*C)
Thank you
R
sum-the-products-along-columns.xlsx
ASKER
Hello Kevin,
Thank you . Great.One Issue; since the rows will be increasing daily, is there a way to make the source column ranges dynamic: in that ranges will get bigger with more rows?
Thanks
R
Thank you . Great.One Issue; since the rows will be increasing daily, is there a way to make the source column ranges dynamic: in that ranges will get bigger with more rows?
Thanks
R
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What you CAN'T do is pass the entire column in to SUMPRODUCT.
Kevin
Kevin
ASKER
Thanks Kevin for the help :)
In fact it is possible to use the whole column in SUMPRODUCT in Excel 2007 or later versions, although probably not advisable due to increased calculation time. This version works, with syntax adjusted so that text in row 4 is ignored
=IF(C5<>C6,SUMPRODUCT((C:C =C5)+0,D:D ,E:E,F:F), "")
regards, barry
=IF(C5<>C6,SUMPRODUCT((C:C
regards, barry
ASKER
Thank you Barry
=IF(C5<>C4,SUMPRODUCT((C$5
Kevin