PDA

View Full Version : Countif wont report 0 if data = 0



jmitch26
2017-09-10, 04:20 AM
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

AliGW
2017-09-10, 07:16 AM
If no data has been entered into WHICH cell?

p45cal
2017-09-10, 11:18 AM
=if(countblank(g72:k72)=5,"",countif(g72:k72,">245"))
?

Bob Phillips
2017-09-10, 04:05 PM
Format it as General;General;

jmitch26
2017-09-11, 04:32 AM
Thank you p45cal that works thanks everyone for the help on this