#119 Learn with Lynda: Go Deeper in Excel with COUNTIF

April 12, 2012

While Excel’s COUNT formula is very helpful, sometimes it doesn’t go far enough. Learn how to use more advanced functions like COUNTIF dig deeper into your data. COUNTIF can be used to count the number of “Yes” responses in a column containing a variety of answers.

Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF