Learn Excel Episode 946: Countif Filtered

Posted in Companies, Podcasts on February 21, 2009

Loh from Malaysia sends in a very hard question. How can you use COUNTIF to analyze only the visible rows from a filtered data set? I knew the solution would have to involve iterating through multiple SUBTOTAL functions, but Aladin from the MrExcel Message board provides the solution. Episode 946 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel