The sum I currently have is:
=SUM($C$4*C6+$D$4*D6+$E$4*E6+$F$4*F6)
I'm looking for a way to insert a range so that I don't have to imput each individual sum.
This spreadsheet will likely be hundreds of columns long by completion so I'm looking for a way to get from $C$4*C6 all the way to (for example) $Z$4*Z6. I haven't been able to come up with anything with my limited knowledge or ranges.
Many thanks for reading.
Sumproduct might work for you but without seeing your details it is hard to tell.
here is an example of how it might work...
take this =B2*B3+C2*C3+D2*D3+E2*E3+F2*F3+G2*G3+H2*H3+I2*I3+J2*J3+K2*K3+L2*L3+M2*M3+N2*N3
and replace with this
=SUMPRODUCT($B$2:$N$2*B3:N3)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Capture1.PNG
That doesn't seem to work unfortunately, thanks for trying though!
I should add that the top part is with SUMPRODUCT used, the bottom part is with the formula that I am currently using without ranges.
I think it would work based on your first post where you noted this... =SUM($C$4*C6+$D$4*D6+$E$4*E6+$F$4*F6)
But based on your screen shot I'm not sure what you are striving for. What you placed in B6 is a modification of the formula I showed you but if what you want is in B14 and B15 those appear to be simple sums across the rows.
Uploading a small spreadsheet with sample data and desired results could be a big help for you to get help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks