COUNTIFS and SUMIFS: Several Conditions
Add an S to test several conditions at once; every condition must be true. Note that for SUMIFS the range to add comes first: SUMIFS(sum_range, range1, criteria1, range2, criteria2). There are also AVERAGEIFS, MAXIFS and MINIFS.
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
In SUMIFS, which argument comes first?
Your turn: write the code
In G1 show the units of Pens sold in the South.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.