COUNTIFS

Dueling Excel – “When Project Finished, Mark All Green”: – Podcast #1877

               

Today in Duel 157, Mike and Bill look at completed project records. If any record for the project is marked Back

Dueling: CountIf 3 Criteria – 1065 – Learn Excel from MrExcel Podcast

               

How to use COUNTIF to count survey answers for a subset of rows. Bill and Mike show many methods in Episode 1065. This blog is the video 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!

Dueling: Frequency Distribution – 1040 – Learn Excel from MrExcel Podcast

               

In this dueling Excel podcast, Bill and Mike look at ways to do a frequency distribution. Episode 1040 shows you how. This blog is the video 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!

MrExcel’s Learn Excel #941 – Count Combinations

               

Sergio from Mexico asks how to count unique combinations of two fields. Episode 941 shows three methods for solving this problem. 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!

Learn Excel from MrExcel