Why do you need 2 columns for "Del" and "ADD"?
When for every row you use only one, then those values can be in same column.
When you are using both of them in same row, then taking into account they add and delete 1, which results in no change at all, so you can left both of those sells empty with exactly same result.

And use tables for data entry - enter table header at top, and data into according rows below header row. This helps you to keep your data organized, and when you look at then after a couple of months later, you'll know what it is about.
An even more advanced approach is to define the data organized in this way as a Table. Then you can use Table syntax formulas, which are expanding automatically whenever you enter new data into defined Table.

Another advice is never enter any initializing values (1000 in your example) directly into table. This can mess up with your formulas, and this isn't obvious at first glance, from where this value is gotten.

Added is an example!

Attached Files

CountingTableExample.xlsx (12.6 KB, 9 views)

Hello Avril, Thank You for your Response. I am sorry - I should have attached my DBCount Sheet, so that my needs would be clear to you - It is now attached.


This is a Simple Support Sheet to my National Rats of Tobruk Database of 21,372 records, that are under constant adjustment. When Additions or Deletions of Members are made to my DB, I record them on this sheet, with other related information.
ADD means to ADD a New Member - DEL means to Remove a Member.
I need to Adjust the Column G (New Count) Automatically on entry, instead of Manually, for accuracy and removal of Human Error.
When complete, this File is sent to my Assistant in another State, to adjust his Parallel Copy of my Database.
ADD and DEL are only in different Columns, so that those Columns can be Individually Added at end of Month.
Can you Please provide a Formula to Auto Adjust "New Count" on entry.
Thank You.

Attached Files

DB RECORD COUNT(1).xlsx (15.7 KB, 8 views)