Countif wont report 0 if data = 0

J

jmitch26

New member
Joined
Sep 9, 2017
Messages
7
Reaction score
0
Points
0
How do I get this display 0 if Data is entered in the cell and leave blank if no data has been entered into the cell?

Currently, it is leaving it blank with this formula when data has been entered into the cell if it = 0

=IF(COUNTIF(G72:K72,">245")=0,"",COUNTIF(G72:K72,">245"))

any help on this will be great
 
=if(countblank(g72:k72)=5,"",countif(g72:k72,">245"))
?
 
Format it as General;General;
 
Thank you p45cal that works thanks everyone for the help on this
 
You must log in or register to reply here.
Back
Top