Running balance column formula not auto adjusting properly in row below when a row is inserted.

JPollard · #1 11-08-2018, 08:52 AM

Quote:

Originally Posted by Marcia

I had to replace this post with a better and I hope correct formula unless a better solution comes up.
Enter the following formula in:
E1 = C1-D1
E2 = SUM($C$1:$C2)-SUM($D$1:$D2), copy the formula down the rows in Col E.

Hi Marcia,
Thanks so much for that. I found this worked well. I found I could enter the full formula in row 1 and copy it down without the need for the first shorter formula.

Also, I found it worked with my added...

=IF(AND(ISBLANK(C4),ISBLANK(D4)),"",SUM($C4:$C$4)-SUM($D4:$D$4))

so that the balance column remains blank under the last entry. I'm fussy like that.

Now I just need to figure out why it works to deeper my learning a little bit!

Marcia · #2 11-08-2018, 02:32 PM

Glad to be of help. This forum is full of very nice and very helpful people. You could shorten the formula a bit.
=IF(AND(C4="",D4=""),"",SUM($C$4:$C4)-SUM($D$4:$D4))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keep balance column empty if no amount entered	baes10	Excel	3	08-14-2018 06:31 AM
Adjusting width of one column	cinci-hal	Word	5	03-08-2018 10:01 PM
Word 10 Tables: Column to auto number 1.1, 1.2 etc in sequential rows	FrauBaker12	Word Tables	7	06-24-2016 11:52 PM
Auto-adjusting Formula (by date)	ShankedS	Excel	2	12-03-2014 03:56 PM
Adjusting column widths	norwood	Word VBA	0	09-24-2013 06:53 AM