In Sheets, with prov in B2:B13 and amount in D2:D13, type the SUMIF that totals the Ontario amounts.
In Sheets, with prov in B2:B13 and amount in D2:D13, type the SUMIF that totals the Ontario amounts.
Answer
=SUMIF(B2:B13, "ON", D2:D13)
Range to test, criterion, range to add — the sum range is LAST. Returns 1995.