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

Use COUNTA not COUNT
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"it''''''''sh hardy" wrote in message
...
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

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

"it''''''''sh hardy" wrote:

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

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(B140,(B1-40)," ") and
SUM the column for total OT hours. YOu could use conditional formatting to
highlight the hours over 40 also.
D

"it''''''''sh hardy" wrote:

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

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

"Brown Recluse" wrote:

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(B140,(B1-40)," ") and
SUM the column for total OT hours. YOu could use conditional formatting to
highlight the hours over 40 also.
D

"it''''''''sh hardy" wrote:

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

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

Much appreciated

"Brown Recluse" wrote:

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(B140,(B1-40)," ") and
SUM the column for total OT hours. YOu could use conditional formatting to
highlight the hours over 40 also.
D

"it''''''''sh hardy" wrote:

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