I am using this formula to deduct for sick time, "=COUNTIF(K17:AL18,"S")*8"
and it works well. I need to add that if the TOTAL Cell (n44) is less than
one an error must flash to prevent the formula from entering a negative
amount.

Thanks for any suggestions you may offer.

Frank