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)