MrExcel's Learn Excel #946 - Countif Filtered
B
Bill Jelen
1 Views • Feb 09, 2009
Description
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!
Discover More
Keywords & Tags
More from User
02:34
MrExcel's Learn Excel #976 - Default Comment
Bill Jelen
03:19
Learn Excel 2010 - "Date Next to a Yes" #1474
Bill Jelen
07:51
Dueling Excel - "Rank Ties by Weight" #1473
Bill Jelen
03:39
Learn Excel 2010 – “Wrap Cells and Resize" #1472
Bill Jelen
02:08
Learn Excel 2010 - "Random with No Repeats" #1471
Bill Jelen
06:30
Learn Excel - "Copy Total to Weeks Macro": #1470
Bill Jelen
Related Videos
00:05
[PDF] EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
Mingdestiny
00:05
Read EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets
Boziek
09:14
How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel
Alonza Darrick
00:27
Read Excel 2007/ Excel Hacks: Los mejores trucos/ Tips Tools for Streamlining Your Spreadsheets
Antonia Olivo
00:57
Professional Excel Templates And Spreadsheets
CFOTemplates
00:42
MS Excel Setting Passwords in Existing Spreadsheets
Smoke Studios