how to exclude/ignore text from a formula

Hello guys,

I am trying to do a timetable in order for the employees to write there time in and out at the stores. in order to see how many saturday Afternoons are in i entered this formula =IF(COUNTA(E13:F13)>0,"A","") .
For counting Sundays (the whole workday) i entered this formula =IF(COUNTA(C14:F14)>0,"WD","") .

This works just fine but if an employee types "off" in the specific range it counts it as if they work(the formula applies).

How to type the formula to applies only when inserting time and ignore the text?

thanks,
Maria

try

COUNT instead of COUNTA

Thanks!!!!!!!!!!!!!!!!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.