How to show an empty cell if =COUNTA counts 0? [Closed]

Report
-
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
-
Hello,
Iam having a bad time, I want to use =COUNTA but I hate the look of all the zeros when in all the empty rows that I didn't use yet, anyway, is there is a way that the =COUNTA command only shows a value if the value is not 0.
Thank You in advance.

1 reply

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi 101lols,

Try using your formula in combination with the IF formula.

=IF(YourFormula=0,"",YourFormula)

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!