Excel 2003 adding row info
 

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.

Excel 2003 adding row info
 

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.

Excel 2003 adding row info
 

Hi,

Suppose your data in in the range A1:Z1 for person 1

=COUNTIF(B1:Z1,"Y")

will count the Y's in that range (assuming the person's name is in A1

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"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.