auto sum

[shannon242801]

working on a PC.  I'm trying to create an auto sum that continuously adds/subtracts from specific columns.  How do I do that.  I know how to create sum for one specific box, but how do i continue it?

B Colum is to be subtracted, C Column is to be addes

12/20/2021		3225	Cobb: Ck#123	17048.33
12/23/2021		200	Jozwiak: Ck#5058	17248.33
12/24/2021		27.35	Square: Tumbler	17275.68
12/24/2021	162.03		Midwest: Ck#1204	17113.65
12/25/2021	44		Gas: Work Truck	17069.65

[#2 · Accepted solution]

@shannon242801 

=F1+C2-B2

Maybe as shown in the attached file with above formula. Every entry in column B and every entry in column C is subtracted or added to the last balance. Above formula is in cell F2 and copied down to cell F5.

[#3]

I got it! Thank you!

[#4]

@OliverScheurich  how to I get auto sum back been working on this for a month