Look in the help index for
COUNTIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Linda" wrote in message
...
Please could you advise if I can query data in a ROW? For example I have
a
name, followed by reasons for non-attendance for many weeks, eg Y (for
yes)
AL (annual leave) etc and want to be able to count the Ys etc for each
person. Thanks a lot.