Thanks Domenic, this works fine.
RC

"Domenic" wrote:

Assuming that Column A contains the 'Ethnic Code', try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A100,ROW(A2:A100)-ROW(A2),0,1)),--(A2:A1
00=D2))

....where D2 contains the 'Ethnic Code' of interest. Adjust the range
accordingly.

Hope this helps!

In article ,
RC wrote:

I have a large amount of student demographic, course, and class data on an
Excel worksheet for an entire school district. The ethnic code for each
student is a single alpha character. I need to find a way to get a total for
each ethnic code in each course when filtering by each course.
Each column of data has a header and I am using the Auto-filter feature for
filtering. Is there a way that the COUNTIF function can be set up for each
ethnic code so that it will count from the filtered data? If not, is there
any other function, or nested functions, that will work?
Thanks,
RC