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

Question

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

[Closed]

Report

101lols - Updated by 101lols on 6/02/17 at 06:55 PM
TrowaD

Posts: 2818
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 18, 2021

- 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?
Can the formula COUNTA / COUNT exclude 0 values? ✓ - Forum - Excel
Find blank cells and replace with 0 ✓ - Forum - Programming
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
Excel if cell contains date then return value ✓ - Forum - Office Software
What values are possible for cells that contain numbers, dates and text? ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2017-02-07T11:24:45-0500

Answer 1 / 1

TrowaD

Posts: 2818
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 18, 2021

486
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

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

1 reply

Your reply

Subscribe To Our Newsletter!