Exercises / Conditional counting and sums · 3 of 11

Total one rep's sales

SUMIF(range, criteria, sum_range) adds the cells of sum_range on the rows where range meets the criteria. Read it as: where to look, what to find, what to add.

Your taskIn G2, use SUMIF to add up the amounts in C2:C11 for the rep named in G1.
Pro

Unlock this exercise and every module after the basics.

Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.

See plansI already have Pro
RowABCDEFG
1DateRepAmountRepAna
21 Jan 2026Ana$1,200.00Total
32 Jan 2026Ben$860.00
42 Jan 2026Cara$430.00
55 Jan 2026Ana$975.00
66 Jan 2026Ben$1,510.00
78 Jan 2026Ana$640.00
89 Jan 2026Cara$2,200.00
912 Jan 2026Ben$390.00
1013 Jan 2026Ana$1,105.00
1115 Jan 2026Cara$780.00