Assume you put these words in column C in C2:C33

Since Absent is zero you only need to count Holidays

=COUNTIF(C2:C32,"Holiday")*8


--
Regards,

Peo Sjoblom

(No private emails please)


"Zack" wrote in message
...
is there a way on a time sheet that when i put Holiday or Absent it will
the
know that each of the words means 8 hours holiday and 0 hours for Absent
on a
time sheet template