Skip to content

Advanced Excel Formulas & Analysis · Exercise 3 of 10 · Conditional calculations · Intermediate · 20 min · Premium

Revenue by Region and Product

Answer five revenue questions with SUMIFS by combining criteria: a region and a product, everything except one product, a name prefix, a unit limit and refunds.

What you will practise: Build SUMIFS criteria from input cells using comparison operators, the not-equal operator and wildcards, and read each criterion the way Excel does.

Premium

This is a Premium exercise

Premium members can open this exercise and practise it in the spreadsheet.

Upgrade to PremiumAlready a member? Open exercise

Open exercise