SUMIF and SUMIFS in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum values in column B where column A equals "Apples".

Google Sheets

=SUMIF(A:A, [1], B:B)

Drag options to blanks, or click blank then click option'

A"A:A"

BApples

CA1

D"Apples"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put text criteria in quotes

Using a cell reference instead of the text

Using the whole column name as a string

The criteria must be a text string in quotes, so use "Apples".

2fill in blank

medium

Complete the formula to sum values in column C where column B is greater than 100.

Google Sheets

=SUMIF(B:B, [1], C:C)

Drag options to blanks, or click blank then click option'

A">100"

B100

C>100

DB1>100

Attempts:

3 left

💡 Hint

Common Mistakes

Using >100 without quotes

Using just 100 without operator

Using a cell reference with operator incorrectly

Criteria with operators must be inside quotes, so use ">100".

3fill in blank

hard

Fix the error in this SUMIFS formula to sum values in D where A is "Bananas" and B is less than 50.

Google Sheets

=SUMIFS(D:D, A:A, [1], B:B, [2])

Drag options to blanks, or click blank then click option'

A<50

BBananas

C"<50"

D"Bananas"

Attempts:

3 left

💡 Hint

Common Mistakes

Not putting text criteria in quotes

Using a cell reference instead of text

Mixing up criteria order

Not putting operator criteria in quotes

The first criteria must be text in quotes: "Bananas" and the second criteria must be "<50" in quotes.

4fill in blank

hard

Fill both blanks to sum values in D where A is "Bananas" and B is less than 50.

Google Sheets

=SUMIFS(D:D, A:A, [1], B:B, [2])

Drag options to blanks, or click blank then click option'

A"Bananas"

BBananas

C"<50"

D<50

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving out quotes around criteria

Using operator without quotes

Swapping criteria order

Both criteria must be strings in quotes: "Bananas" and "<50".

5fill in blank

hard

Fill all three blanks to sum values in E where A is "Oranges", B is greater than 20, and C equals "Yes".

Google Sheets

=SUMIFS(E:E, A:A, [1], B:B, [2], C:C, [3])

Drag options to blanks, or click blank then click option'

A"Oranges"

B">20"

C"Yes"

DYes

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting text criteria

Not quoting operator criteria

Using raw Yes without quotes

All criteria must be strings in quotes: "Oranges", ">20", and "Yes".