Excel 2003 adding row info

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

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel adding a row - follow up to replies 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Delete row 'if' 4
Count 1
Smart way to concatenate into B1 all cells below until new info in Column A 1
vlookup---using data outside the range specified in the formula 4
using vlookup to find data outside a specified range 1
Sum of Services Provided Check Box 2

Top