MrExcel's Learn Excel #946 - Countif Filtered

Tags:: Excel Business Accounting Spreadsheets Tutorials Technology Mrexcel Countif Filter

Edit Video Details

Share
Add to Favorites
Report
Download

By: MrExcel
Subscribers: 10
Updated: 18-Dec-09
Videos: 231

International
Comments: 0
Views: 108
Added: 09-Feb-09

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.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!