Hi,
I wanted the count the number of times a range contains the text 'Yes'.
The cells in this range all contain formulas.
How do I reference the cell value (Yes) in my formula?
I'm using =COUNT(AG5:AG99 = "Yes")
Gerry
Hi,
I wanted the count the number of times a range contains the text 'Yes'.
The cells in this range all contain formulas.
How do I reference the cell value (Yes) in my formula?
I'm using =COUNT(AG5:AG99 = "Yes")
Gerry
=COUNTIF(AG5:AG99,"Yes")
Ah, spot on. Thanks alot.
Gerry
Please close this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks