sumproduct?

[dsforbes]

I inherited a spreadsheet that has 20 columns of values for our mutual funds. The top row contains the fee and the formula is as follows to calculated a total for all.

=(G8*$G$6)+(J8*$J$6)+(I8*$I$6)+(H8*$H$6)+(M8*$M$6)+(N8*$N$6)+(O8*$O$6)+(L8*$L$6)+(Q8*$Q$6)+(R8*$R$6)+(T8*$T$6)+(S8*$S$6)+(P8*$P$6) and so on


row 6 .0075 .0068 .005
Client Name Total Fee Fund 1 Fund 2 Fund 3 ....
value value value

There has to be an easier formula without adding an intermediary column and then summing for each fund.

 

[MrKowz]

Your subject line is actually the solution!

=SUMPRODUCT(G8:P8,$G$6:$P$6)
(extend the ranges out to the end of your actual data)

 

[Jonmo1]

Sumproduct should work here...

I'm assuming that's not the whole formula, L is the only column missing between G and T..

Try

=SUMPRODUCT(G8:T8,$G$6:$T$6)

If L was left out intentionally, just subtract it from the result..

=SUMPRODUCT(G8:T8,$G$6:$T$6)-(L6*$L$6)

Hope that helps.

 

[dsforbes]

great, I thought that was the right formula, but wasn't sure how to use it.
Thanks so much.

 

[MrKowz]

great, I thought that was the right formula, but wasn't sure how to use it.
Thanks so much.

You're welcome. Thank you for the feedback.