Skip navigation

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

Using SUMIF, COUNTIF, and related functions for quick data analysis: Excel 2016: Managing and Analyzing Data
Using SUMIF, COUNTIF, and related functions for quick data analysis: Excel 2016: Managing and Analyzing Data

Use COUNTIF to count the number of occurrences of data within a range. Use SUMIF and AVERAGEIF to expand this functionality by tabulating data in a parallel range. Use the COUNTIFS, SUMIFS and AVERAGEIFS functions to count the number of occurrences based on multiple criteria, all of which must be met.

Resume Transcript Auto-Scroll
Skill Level Intermediate
3h
Duration
93,649
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now