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