Countif problem


I’m trying to retain an count.

My spreadsheet is designed to count the cells labelled “Enquired” and then count. But during my process, cells are changed to other values but I would like to retain the original count automatically.

For example, I will use data vailidatio to label several cells as “Enquired”, and at this point i would like the cells labelled this to be counted. I will then in future use the data validation to change these cells to other words. But then the count will drop. How do i keep that original count?

-Thank you


By: Danny97

Leave a Reply

Your email address will not be published. Required fields are marked *