Adding rows based on no of rows specified from a given position

  • Thread starter Thread starter nanette
  • Start date Start date
N

nanette

hi there.

how can i add the contents of the rows given the number of rows to add?

i.e.
a1 = 1
a2 = 2
a3 = 3
a4 = 4
a5 = 5

if b1 = no of rows to add = 3
then c1 = ? formula to sum up a1:a3 = 6

if b2 = no of rows to add = 2
then c2 = ? formula to sum up a4:a5 = 9

thanks very much.
 
You can do that like this in C1:

=SUM(INDIRECT("A1:A"&B1))

and this one in C2:

=SUM(INDIRECT("A"&B1+1&":A"&B1+B2))

Hope this helps.

Pete
 
Back
Top