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.