Administration and Executive AssistantTier 160 minbeginner

SUM and COUNT Families

The workhorse functions used in nearly every analysis.

What you will learn

• Use SUM for totals and SUMIF for conditional sums
• Know the difference between COUNT, COUNTA, and COUNTIF
• Understand SUMPRODUCT for weighted totals
• Apply SUMIFS and COUNTIFS for multiple conditions
• Use range names in these functions

Excel skills

SUM, SUMIF, COUNT, COUNTA, COUNTIF, SUMIFS, COUNTIFS, SUMPRODUCT · Aggregation Functions

The task

The Transactions tab has a hundred expense lines. The Summary tab already lists the eight categories. I need the total spend and the number of transactions for each one.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free