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

Closed

101lols - Updated by 101lols on 6/02/17 at 06:55 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 7, 2017 at 11:24 AM

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.

How to show an empty cell if =COUNTA counts 0?
//192.168.l.0 - Guide
If cell contains date then return value ✓ - Office Software Forum
If cell contains specific text then return value in another cell ✓ - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 7, 2017 at 11:24 AM

Hi 101lols,

Try using your formula in combination with the IF formula.

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

Best regards,
Trowa

Similar discussions

,">"&0),"") at the end of a countif formula

Counting cells containing only numbers

How to use conditional format based on text?

Excel - IF function with multiple words

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!