# Can I create a range with absolute cell references and multiple sums?

1. ## Can I create a range with absolute cell references and multiple sums?

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.

2. ## Re: Can I create a range with absolute cell references and multiple sums?

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)

3. ## Re: Can I create a range with absolute cell references and multiple sums?

Capture1.PNG

That doesn't seem to work unfortunately, thanks for trying though!

4. ## Re: Can I create a range with absolute cell references and multiple sums?

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.

5. ## Re: Can I create a range with absolute cell references and multiple sums?

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

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1