Hi,
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.