COUNTIF, SUMIF and AVERAGEIF
These answer "how many / how much / what average, for the rows that match a condition". COUNTIF(range, criteria), SUMIF(range, criteria, sum_range) and AVERAGEIF(range, criteria, average_range). Criteria can be text ("North"), a number, or a comparison in quotes (">5"). Wildcards work in text: "P*" means starts with P.
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.
What does `=SUMIF(A2:A6,"North",C2:C6)` do?
In G1 show the total units sold of Books.
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.