Administration and Executive AssistantTier 250 minintermediate

SUMIFS, COUNTIFS, and MAXIFS Family

Sum, count, or find max/min with multiple conditions.

What you will learn

• Use SUMIFS for conditional sums across multiple criteria
• Understand COUNTIFS for conditional counts
• Use MAXIFS, MINIFS, and AVERAGEIFS
• Combine with date ranges for period analysis

Excel skills

SUMIFS, COUNTIFS, MAXIFS, MINIFS, AVERAGEIFS, AVERAGEIF · Multi-Condition Aggregation

The task

The Records tab has budget and actual spend for every department, every month. I need one department's one month pulled out onto the Summary tab: budget, actual, and the variance between them.

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