LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default Subtotal command problem

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested subtotal display error phil Excel Discussion (Misc queries) 3 October 24th 06 09:16 AM
SUBTOTAL - TJ TJ Excel Worksheet Functions 4 March 22nd 06 06:06 PM
subtotal a range of cells on a different worksheet cheryl Excel Worksheet Functions 0 November 2nd 05 08:37 PM
Subtotal Bug in Excel 2003 GON Excel Discussion (Misc queries) 2 May 10th 05 08:42 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"