Excel Formula Help

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Is the following possible in Microsoft Excel, and if so, how?

Let's say I have a worksheet with the following cell values:

A2: 5
A3: 7
A4: 10
A5: 2
A6: 7

Now, what I'd like to be able to do is have a cell, let's say A10 which
will give the SUM of A2-A? where ? is a number specified in cell C1.
So if I put in a 4 in C1, cell A10 would read 22. If I put in a 6 in
cell C1, cell A10 would read 31.

Can anyone help me here?

Thanks!
 
You already have an excellent solution. Here's just another way to add to
your library:

=SUM(OFFSET(A2,,,C1-1))

HTH
 
Back
Top