Forum Discussion
shannon242801
Dec 27, 2021Copper Contributor
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?...
- Dec 27, 2021
=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
Dec 27, 2021Gold Contributor
=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.
shannon242801
Dec 27, 2021Copper Contributor
I got it! Thank you!