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
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.
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.
Related:
- Xbox-2309-1001-3-0
- Xbox App - Download - Digital stores
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Xbox backup creator - Download - Backup and recovery
- Xbox 360 controller driver - Download - Drivers
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 7, 2017 at 11:24 AM
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
Try using your formula in combination with the IF formula.
=IF(YourFormula=0,"",YourFormula)
Best regards,
Trowa
