Share via

Increment cell reference within a formula

Anonymous
2018-12-24T18:34:00+00:00

Hello, 

I have a formula that sums a group of cells after each cell is multiplied by another cell. The formula is relatively easy with the exception that I need to reference 366 different cells in incremtal order. Please see below

=(G15*H16)+(G16*H16)+(G17*H17)+(G18*H18)....................183 times. 

Is there any way to speed the process up so I don't have to hand type every single cell reference?

Thanks!

Adam

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-12-24T18:39:45+00:00

Hi Adam

The formula you need is SUMPRODUCT

=SUMPRODUCT(G15:G198,H15:H198)

Please check if G198 is your last value . . .

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-12-24T20:17:50+00:00

    Thank you much!

    Was this answer helpful?

    0 comments