Excel 2003 adding row info

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

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.
 
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
 
Back
Top