Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Will the COUNTIF function work with auto-filtering?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Extend Formulas doesn't work for a particular formula | Excel Discussion (Misc queries) | |||
COUNTIF doesnt work! | Excel Worksheet Functions | |||
How can I use the NOW function and keep it from auto updating? | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Countif Function -Nested | Excel Discussion (Misc queries) |