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 Formulas 6
join multiple queries in one query "Attendance calculation" 3
Counting how many numbers and letters appear in a particular row 7
the sum of a row based on condition of a dropdown box 2
Attendance formula for payroll please help 0
SUM “every 4th cell†in a row 7
VBA Macro Training in Chennai 0

Top