---
title: "Quota Attainment With SUMIFS — Sales Excel Practice | SheetDo"
url: https://stacklist.com/card/852f536f-333b-4263-99f6-8cc65473411c
source_url: "https://sheetdo.com/practice/quota-attainment/?utm_source=stacklist&utm_medium=directory&utm_campaign=excel-sales-rep-stack"
stack: https://stacklist.com/c/business/stack/c63a8f97-5e08-4630-8e71-f2794bad0e8b
summary: "Quota Attainment is a practice problem on SheetDo that teaches how to calculate sales rep quota attainment using SUMIFS formulas. The exercise requires dividing total bookings by quota to produce a decimal attainment percentage for any selected rep."
tags: "quota-attainment, spreadsheet, sumifs, sales-analytics, excel-formula, practice-problem"
key_entities: "SheetDo (organization), Ada (person), Ben (person), Cleo (person), SUMIFS (technology), quota-attainment (concept)"
classification: "tutorial"
content_hash: "sha256:2ac510f929537ed8738a7345f63d77b885afa48085acfb4c7010b34bca493cc9"
acp_version: "0.2"
token_counts_approximate: 539
visibility: public
agent_accessible: true
status: "final"
---

# Quota Attainment With SUMIFS — Sales Excel Practice | SheetDo

Practice problems / Math Quota attainment for one rep (SUMIFS ÷ quota) Easy Math Sales pack SheetDo · Updated November 4, 2026 Description Hints 0/4 Solutions 0 – Test case 1 Reset Submit fx A B C D E F G 1 2 3 4 5 6 7 8 9 10 Loading interactive spreadsheet... Preparing grid cells and formula calculation engine ○ Ready Enter formula in highlighted cells, then click Submit. Description Hints 0/4 Solutions 0 – Test case 1 Reset Submit fx A B C D E F G 1 2 3 4 5 6 7 8 9 10 Loading interactive spreadsheet... Preparing grid cells and formula calculation engine ○ Ready Enter formula in highlighted cells, then click Submit. The problem Problem statement Bookings are logged per rep in A2:C7 , and the rep to report is F1 with their quota in F2 . Put that rep's attainment — bookings divided by quota, as a decimal — in the Attainment cell F3 . The rep and the quota both come from cells; the same formula has to answer for any rep. Problem data Show the sheet as a table (selectable, copyable) Copy as TSV The exercise data, as a table A B C E F 1 Rep Region Amount Rep Ada 2 Ada East 500 Quota 1000 3 Ben West 300 Attainment 4 Ada East 200 5 Cleo North 400 6 Ada West 100 7 Ben West 250 Notes SUMIFS collapses the booking log to one number per rep, and dividing by the quota turns it into attainment. 0.8 means 80% — keep it as a decimal and format the cell, rather than writing "80%" as text. How to approach Your answer goes in F3. Target cell is F3 Total the bookings for F1 first Divide that by F2 Shape: =SUMIFS(?, ?, ?) / ? Function guide SUMIFS · SUMIF Related practice Invoiced minus paid, per vendor (two SUMIFS) Paid or outstanding? (SUMIFS + IF) Regional sales with two filters (SUMIFS) Running balance per account (expanding SUMIFS) All practice problems → FAQ How do I calculate quota attainment? Bookings for the rep divided by the quota: =SUMIFS(amounts, reps, rep) / quota. Keep the result as a decimal and format it as a percentage. Why does my attainment look like 80 instead of 0.8? The quota was probably entered as 10 instead of 1000, or the formula multiplies by 100. Divide once, and let the number format show the percent sign.