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.