ITS Online

#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
Excel 2010: Advanced Formulas and Functions | by Dennis Taylor

Latest News

  • Image preview
    eduroam is a secured wireless network that allows students, faculty and staff to use their home institution’s credentials (for Penn affiliates, their PennKey) to access wireless network services, when visiting other eduroam participating institutions without having to set up a guest account.
  • Image preview
    Apple has released updates to address multiple vulnerabilities that have been discovered in Apple’s OS X, Safari, iOS, and Xcode products that could allow remote code execution.