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?
|