Help Programming Excel Sheet!

[it''''''''sh hardy]

So I'm creating an excel shee for work to calculate OT in my store, but am
having an issue with formatting, here is what I have:

Employee Name
Employee Name
Employee Name
Employee Name
Employee Name
(Total Number of employees with OT)

But because there is names not numbers it is giving me an error... Any
suggestions?

Thanks

 

[Mike H]

Hi,

Perhaps you could give a clearer explanation of what your trying to do and
the formula that's giving and error. Someone will help.

Mike

 

[Bernard Liengme]

Use COUNTA not COUNT
best wishes

 

[Brown Recluse]

Not sure if this is what you want: but, if the names appeared in A1, A2, A3,
A4 and A5 and you wanted to count the names of those that have OT you could
use =counta(A1:A4). Or you could use a formula that highlights any hours
over 40 hrs, such as if the hours were in Column B =if(B1>40,(B1-40)," ") and
SUM the column for total OT hours. YOu could use conditional formatting to
highlight the hours over 40 also.
D

 

[JLatham]

You beat me to the "COUNTA()" punch, it was what I was going to suggest,
barring any more info from the OP.

 

[it''''''''sh hardy]

Thanks!!! That's exactly what I needed!!!

Much appreciated