#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

  • This year a new Special print account is being added for all Penn Law students. This account is to be used when printing for approved group and programs. All other printing remains the same, please read on for more details.
  • AirPennNet-Guest Wifi will be upgraded on April 27th. Device registration will require just an email address and guests will need to renew registration daily. Penn Law faculty, staff and students should all be using AirPennNet – not AirPennNet-Guest for Wifi.