| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 adding page breaks | Excel Discussion (Misc queries) | |||
| Adding Colum to a Row od info... | New Users to Excel | |||
| Adding Info to Chart | Charts and Charting in Excel | |||
| Adding a 2nd row of sheet tabs to Excel 2003 | Excel Discussion (Misc queries) | |||
| Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
Linear Mode
