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

    Join us Friday, November 13 at noon in Gittis 213.
    Learn about new features in Office 365 that will give you the flexibility to work and collaborate across devices and locations. This includes Office Web Apps, Skype for Business and the new Office 365 WebMail.

  • Image preview
    The Center for Computer Assisted Legal Instruction, also known as CALI, provides online interactive tutorials on various legal subjects.  Tutorials are authored by law faculty and peer reviewed by a member of the CALI Editorial Board.  Here is information on how to create an account and access the materials.