How to eliminate false counts on created date (auto-number deleted line items)
Hi there,
Thanks for helping with this. I'm creating a sheet summary formula that does a count of items created within a specific year. All good there. =COUNTIFS([C-Year]:[C-Year], "2022")
The wrinkle is that the sheet has autonumbering and so I'm getting a false count with 4 items that were created and then deleted. No new item has been added since then.
The deleted rows are counted. Trying to add detection/a criteria not to count, where the Primary Column is blank doesn't seem to work, likely because these rows aren't there.
Anyone else run into this issue with auto-numbered row sheet summaries?
Suggestions to fix?
It only seems to be counting the most recent deletions so if this self corrects when these deleted items aren't the last rows I can probably live with it.
Best Answer
-
Solved this myself with coffee and
=COUNTIFS([C-Year]:[C-Year], "2022", [Primary Column]:[Primary Column], <>"")
but still a bit spooked about having deleted content appear in stats because of a system generated ID number. Are there any suggested best practices around this?
Answers
-
Solved this myself with coffee and
=COUNTIFS([C-Year]:[C-Year], "2022", [Primary Column]:[Primary Column], <>"")
but still a bit spooked about having deleted content appear in stats because of a system generated ID number. Are there any suggested best practices around this?
Help Article Resources
Categories
Check out the Formula Handbook template!