How do I remove a zero from a cell when using the COUNTM function?

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", ""

Jason Duryea

=IF(COUNTM([Member Email Campaign Opt-In]@row)>0, COUNTM([Member Email Campaign Opt-In]@row), “”)