How to Use SUMIF, COUNTIF, and Related Tools in Excel 2010


show more Using SUMIF, COUNTIF, and related functions for quick data analysis provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Using SUMIF, COUNTIF, and related functions for quick data analysis

The SUMIF/COUNTIF family of functions, introduced in Excel 97, now include four new functions in Excel 2007 and they give you lots of tools for tabulating a variety of statistical totals when you have database type lists. The functions and questions are listed in Column J here. Normally you wouldn't see these listed just like this, and I've separated them because they're more or less in groupings here. SUMIF, COUNTIF and AVERAGEIF. AVERAGEIF is new in Excel 2007.

And these functions you can almost figure out what they do by their names. This list here is substantial. It might grow, it might shrink. And we might want to know, for example, simple question, how many half-time people do we have, how many full-time people do we have? So start off actually with COUNTIF and use this function right here, =COUNTIF. Two arguments. Where are we looking? Now you certainly can and I certainly could here highlight all of the cells in Column D, but it's a lot simpler to simply click Colu...

Using SUMIF, COUNTIF, and related functions for quick data analysis
Video duration: 6m 48s 1h 32m Appropriate for all

Viewers:

Using SUMIF, COUNTIF, and related functions for quick data analysis provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...