just a little help with this formula---

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
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PAYROLL ISSUES 1
Dcount -Date Criteria - Won´t find it - 0
Match Date range with two digit Number (year) 4
Count Number of Unique Cells That Don't Have Certain Characters 0
Countif or other formula needed for multiple data/critera results 3
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Newbie Help - IF Yes No Function 0
COUNTIF - help please 10

Top