MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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