I have a series of values that I’d like to perform a running total on. There are multiple values across the top in Row 1 starting at Column B. In the cells beneath, I’d like to calculate the running total of the values in the cell above, plus any to the left of that cell, but not to include Column A. I could create a unique formula for each cell, but I'm looking for a formula that I can copy across Row 2
Please Login or Register to view this content.
In Cell B2 put this formula and pull it across
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
In B2 would be: =B1
In C2 would be: =IF(C1="","",SUM($B1:C1) and drag across
Hi
In B2
=B1
In C2 and copy cross.
=C1+B2
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Wow, it was that simple I couldn't see it...many thanks for the quick response, much appreciated.
Originally Posted by MarvinP
In Cell B2 put this formula and pull it across
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks