Sum
Posted by Lukas Weder on November 09, 2001 9:27 AM
Hi!
First: Thanx for the XXL-Pivottable answers!!!
I have a new little problem. Row A contains a lot of numbers. In Row B I wanna calculate the following sum:
B1 = A1
B2 = A1+A2
B3 = A1+A2+A3
....
Is there another possibility than using a macro or the offset() function?
thanx a lot!
Lukas
Posted by IML on November 09, 2001 9:30 AM
In B1, enter
=SUM($A$1:A1)
and copy it down.
Posted by Juan Pablo on November 09, 2001 9:31 AM
Use this formula in B1 and drag down
=SUM(A$1:A1)
Juan Pablo
Posted by Lukas Weder on November 09, 2001 9:41 AM
Thank you guys for the extremely quick answer!!!
