In Sheets, with provinces in B2:B13 and amounts in D2:D13, type the formula for the mean amount of the BC orders.
In Sheets, with provinces in B2:B13 and amounts in D2:D13, type the formula for the mean amount of the BC orders.
Answer
=AVERAGEIF(B2:B13, "BC", D2:D13)
Range to test, criterion, range to average — the same order as SUMIF. Returns 1360 / 3 = 453.33.