How would you write a formula down a column that sums an adjacent one, just up to the each row? Say you have under column A various inputted values and in B we'll put this SUM formula.
I assume "SUM" will be in there. But how do you get each row to update the formula to cut the range at the current row? Is t this possible?
Assuming the data starts in row 2, thendragged down gives a running total up to the current row.Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Oh, easy! Makes sense. Thanks. You da man!
Excel 1.0.1 (16.0.14326.20140) (Android)
Excel 2010 14.04.4760.1000
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks