SUMIF discovery — Sales portfolio
Total up a sales portfolio by salesperson, region and product using SUMIF, both with a fixed value and with a cell reference — 6 guided steps.
=SUMIF( criteria_range , "criteria" , sum_range )
1 / 6
Martin's total revenue
=SUMIF(A2:A16,"Martin",E2:E16)
=SUMIF( criteria_range , cell , sum_range )
2 / 6
Total revenue with a cell reference
=SUMIF(A2:A16,G1,E2:E16)
3 / 6
Total revenue for the North region
=SUMIF(C2:C16,"North",E2:E16)
4 / 6
Total revenue with a cell reference (2)
=SUMIF(C2:C16,G1,E2:E16)
5 / 6
Total revenue for Pro License
=SUMIF(D2:D16,"Pro License",E2:E16)
6 / 6
Total revenue with a cell reference (3)
=SUMIF(D2:D16,G1,E2:E16)
Your score is
Restart
