MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Countif within filtered subtotals


Posted by John Brookes on October 17, 2001 11:10 AM

This query is similar to "How do I not Subtotal cells with no value? - A Miller 05:13:31 09/11/01". I want to apply a COUNTIF function to a list which has been filtered. I need to count cells which contain certain criteria but only those which have not been filtered out. What i need is a "SUBTOTALIF" but i am not good enough at VB to write this function and all of the nested functions i have tried have failed. Help please.


Posted by Mark W. on October 17, 2001 11:45 AM

What's your criteria -- including your filter criteria? (nt)

Posted by john brookes on October 17, 2001 11:21 PM

Re: What's your criteria -- including your filter criteria? (nt)

The criteria for the filter is text. The data in the work sheet contains company employee information so i may want to filter the sheet by, say, employees who work from a certain office. The subtotal needs to count information about the employees, say, do they have medical insurance. I have done this previously by adding another column and putting an "IF" function in and then hiding this column and using a subtotal to count this hidden column. However this is not a very elegant solution to my problem.