Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. Logic & Conditional Math

SUMIF and SUMIFS Practice Exercises (+ AVERAGEIFS, SUMPRODUCT)

Totals by region, by product, above a threshold — the way reports are actually built.

5 exercises, about 32 min

  1. 27Sales by region with SUMIFBeginner~5 minBeginner, ~5 min
  2. 28Total of orders above $500Beginner~4 minBeginner, ~4 min
  3. 29Sales by region and product with SUMIFSIntermediate~7 minIntermediate, ~7 min
  4. 30Average and largest deal per rep (AVERAGEIFS, MAXIFS)Intermediate~8 minIntermediate, ~8 min
  5. 54Weighted average price with SUMPRODUCTExpert~8 minExpert, ~8 min