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
    Email scams often appear to originate from a legitimate and reputable source. Please take care and notify ITS of any suspicious emails. Your security is always worth our time.
  • Image preview
    Firefox has recently released update 35.0 including a few new features. However, you might wish to switch your default search engine with this update as your preferences may have changed.