In Sheets, with prov in B2:B13 and amount in D2:D13, type the formula that counts the Ontario orders over $400.
In Sheets, with prov in B2:B13 and amount in D2:D13, type the formula that counts the Ontario orders over $400.
Answer
=COUNTIFS(B2:B13, "ON", D2:D13, ">400")
Range, criterion, range, criterion. The comparison is text in quotes. Returns 3.