I have a formula in a cell that checks values and outputs "YES" or "NO"
This formula is in all cells in a column, so it looks something like this:
YES
NO
YES
YES
YES
NO
etc
I want to count all "YES" values.
It would be easy if I had typed it in, but as its a return value of a formula, how do I count all "YES" values?
Thanks
This formula is in all cells in a column, so it looks something like this:
YES
NO
YES
YES
YES
NO
etc
I want to count all "YES" values.
It would be easy if I had typed it in, but as its a return value of a formula, how do I count all "YES" values?
Thanks