SUMIF FUNCTION
 

For hourly employee, I need to add total hours for each day. But some day,
they are off. I put " off" in this case. The format like this:
A
1. 8
2. 3
3. OFF
4. 5
5.6
=SUM()? I know, I can find that one,then take it our. But I have 100
employees to calculate. In this case, what I should do?

=SUM(A1:A5)

SUM will ignore text.

HTH
Jason
Atlanta, GA

-----Original Message-----
For hourly employee, I need to add total hours for each
day. But some day,
they are off. I put " off" in this case. The format like
this:
A
1. 8
2. 3
3. OFF
4. 5
5.6
=SUM()? I know, I can find that one,then take it our.
But I have 100
employees to calculate. In this case, what I should do?

.