How do I remove a zero from a cell when using the COUNTM function?
Options
Bob Kernan
✭✭
I have columns that use COUNTM.
Some of the results come back with 0 as the value. I want to leave the cell blank in this case
=COUNTM([Member Email Campaign Opt-In]@row)
I suspect I need to include an "IF" statement where "0", ""
Answers
-
=IF(COUNTM([Member Email Campaign Opt-In]@row)>0, COUNTM([Member Email Campaign Opt-In]@row), “”)