Looking for a sum function that counts rows, however when a row is to be deleted in the future it will not be actually deleted. A comment is added in a comments column that will say 'DELETED'. This needs to be reflected in the count ie the count should drop when a row is deleted in this way.
Try
=COUNTA(A:A)-COUNTIF(A:A,"Deleted")
where Column A contains your data. Adapt for your data range
Life's a spreadsheet, Excel!
Say thanks, Click *
Works perfect and thank you for your fast response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks