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

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.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding specifics columns and rows 1
conditional formating adjacent rows 4
Comparison of columns using Conditional Formatting 3
Finding last cell with a value and then adding to another 2
Add rows depend on the number in a cell 3
Add Rows depends on the number in a cell 1
Calculating a sum from a given number of rows 3
formula that writes to a *different* cell? 4

Top