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.