Forum Discussion

shannon242801's avatar
shannon242801
Copper Contributor
Dec 27, 2021
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?...
  • OliverScheurich's avatar
    Dec 27, 2021

    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.

Resources