Mar 30 2020 07:33 AM
I am trying to autosum in one cell. For instance, I have a category for gas receipts. I have $10 in that cell. I want to add a $5 receipt. When I enter 5 in that cell I want it to automatically add it to the 10 already in that cell, and keep going everytime I add a new receipt all year. Is this possible?
Mar 30 2020 07:47 AM - edited Mar 30 2020 08:11 AM
Perhaps the solution is demonstrated in the attached workbook by using SUMIF.
Mar 30 2020 08:02 AM
Mar 30 2020 08:05 AM
@Abiola1 No this is what I have
10 in A2, I want to add 5 to A2, then just keep adding to A2 all year long.
Mar 30 2020 08:11 AM
That's with VBA programming, but I'd reconsider data model. Assume you have misprints, other data correction - that will be not easy task if entire history of changes is within log for A2.
Mar 30 2020 08:15 AM