Marking a counted row


I have a table which I count how many rows have a specific value with lots of countif functions.
I need to either highlight the cells or preferably have a value of say “counted” in the empty cell next to that particular row.

How would I do that?

I think it’s easier to identify the lines to count in a cell and then count these cells.

It’s easier to say if you have a template file.

Try to use the Conditional Formatting feature parallelly with the COUNTIF() function. Use a similar condition what you use in the countif function. These two features are independent, but the result may will appropriate for you.