~/ learn/ afm-112/ cards/ The sum range moves first in the plural form
1 of 11

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.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/fc53356f-a52c-4ab9-964c-2ba0b50c284b/flashcard utf-8 LF