moderated Re: MS EXCEL formula
toggle quoted messageShow quoted text
Is there a formula where the running balance/total can be in column E for example? Example: row 14 column D has $22.50 and this should be seen in same row 14 but column E. The next row, 15, has in column D $220.59 and row 15, column E should have the running total or sum. This would go down all rows and columns. Is this possible or just the total somewhere at the bottom cell where the total would be seen?
From: email@example.com <firstname.lastname@example.org> On Behalf Of Richard Turner
Sent: Sunday, January 12, 2020 10:55 PM
Subject: Re: MS EXCEL formula
You can put the formula anywhere in column e that you want the total to be.
The formula should be =sum(d14:d100)
Equals sum tells excel that you want to add numbers together.
open parenthesis d14 colon d100 close parenthesis tells it to add d14 through d100.
"Reality is the leading cause of stress for those who are in touch with it."
-- from The Search for Signs of Intelligent Life in the Universe, by Jane Wagner