Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I have a spreadsheet to analyse student performance. Column AJ contains text values "OVR" "UND" and "ACH" to indicate if the students has over or under achieved a predicted grade. Column N contians "y" or "n" to indicate if the student has recieved additional support during the term. What I would like to do is auto filter column N to show only the students who have had additional help and then use a formula to count the number of "OVR" in the visible cells of col AJ I thought =SUBTOTAL(3,AJ7:AJ37) had done the job but it counts all the entries not just the "OVR" entries Thanks if you are able to assist Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested subtotal display error | Excel Discussion (Misc queries) | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |