Hi,

If you have filtered on L1 and want to count the total number of visible
cells of the filtered range, then you can use the SUBTOTAL() function

=subtotal(3,J1:J692)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"pmdoherty" wrote in message
...
I have a constantly updated master sheet of individual student's exam
results
- in one column the exam levels, "L1" or "L2", in another "A" achieved,
"Nr"
nearly achieved "NA" not achieved.
I then use "=master sheet:a1" etc to mirror all information to a number of
new sheets in the same document where the data is autofiltered by course
code, to show only results of each specified faculty.

What I have been attempting to do is to simply use =COUNTIF(J1:J692,"L1")
to
get a total of the number of students who have sat Level 1. The problem
is
that when i do this, it is also counting the "hidden" entries that are not
part of the filter.

Could anyone please advise on a method of counting ONLY the results shown
after i fun my auto-filter?

Thanks a lot,
Paul