Simple count

Craig Lemberger

=COUNTIF({Client Name Spring Data}, [Client Name]@row)

This formula is bringing me the correct answer. However, if the answer is zero, I'd rather the cell remain blank. I tried doing another If formula outside the countif but to no avail. I KNOW there is a simple fix.

Thanks in advance :)

kristin.parrott

Hi!!

I would think the IF statement in front of it should work - can you share the formula you tried?

This is what I would try!

=IF(COUNTIF({Client Name Spring Data}, [Client Name]@row)=0, "" , COUNTIF({Client Name Spring Data}, [Client Name]@row))

Craig Lemberger

Hi Kristin,

Thank you.

Yes I tried something similar, but I did not punctuate property.

You fixed it for me!! Much appreciated.