just a little help with this formula---

  • Thread starter Thread starter john
  • Start date Start date
J

john

I need to ad something to this formula that will make
return the #0 if their is no count...

=IF(COUNT(C_TIME,T_TIME)=0,"",IF(COUNT(C_TIME,T_TIME)
<7,COUNT(C_TIME,T_TIME),7))


Thanks
JOHN
 
how about changing this to suit your names
=IF(COUNT(F3:F5)=0,0,MAX(COUNT(F3:F5),7))
 
Back
Top