I'm fairly new to Excel so please forgive me if this is a simple fix. My searches have come up with nothing.
I have a column of text ranging from A84 through A237. I need to count the number of occurrences within that range of cells then display the total, but if the total is 0, I need it to display "N/A".
Here is my formula that returns 0 when none are found. Basic stuff.
=COUNTIF($A$84:$A$237,"TEXT")
I've tried this with no success (I didn't expected it to work since B25 is my target cell):
=IF($B$25=0,"N/A",COUNTIF($A$84:$A$237,"TEXT"))
I've looked into Conditional Formatting but it won't insert text when 0, it only highlights, bolds, etc.
Sigh...
Any help is appreciated!
Bookmarks