Forum Discussion
Solved
auto sum
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 |
=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.
=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.
OliverScheurich how to I get auto sum back been working on this for a month
- I got it! Thank you!
