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!