Conditional Calculations
What you will be able to do
- Add up, count and average with conditions
- Use operators, wildcards and date ranges in criteria
- Use SUMPRODUCT for weighted and multi-condition totals
- Build and reconcile summary tables
13 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: Module 1
- SUMIF
- SUMIFS with several conditions
- Criteria with operators and cell references
- Wildcards in criteria
- Date criteria
- COUNTIF and COUNTIFS
- AVERAGEIF and AVERAGEIFS
- MAXIFS and MINIFS
Module 2: Module 2
- SUMPRODUCT basics
- SUMPRODUCT with conditions
- Summary table with SUMIFS and mixed references
- Reconciling a summary to its detail
Project: sales and expense summary by region and month
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free