formula to make the value in a cell, to a row in a sum function

M

Maulwy

Dear All,

if i had data:
A B C
1 1 7 8
2 1 5 5
3 1 6 6
4 1 10 14
5 1
6 1
7 2
8 2
9 2
10 2


where the cell C1 is the sum of cells a1 - A7, C2 cell is a sum of cells a1
- a5, cell c3 is the sum of cells a1 - a6 and d4 cells is a sum of cells a1 -
A10. What formula can make this addition, which I've tried IF functions, but
not efficient when the cell "A" continue to grow it.

When concluded, what is written in cell B1, a limit on the sum of column "A".

Thanks before,

Rgds,
Maulwy
 
J

Jacob Skaria

In C1 and copy down
=SUM(INDIRECT("A1:A" & B1))

If this post helps click Yes
 

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

Top