Value aggregation (SUM, COUNT, AVG) in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the SUM function do in Google Sheets?

The SUM function adds up all the numbers in a range of cells and gives you the total.

beginner

How does the COUNT function work?

COUNT counts how many cells in a range contain numbers. It ignores empty cells and text.

beginner

What is the purpose of the AVERAGE function?

AVERAGE calculates the average (mean) of numbers in a range by adding them and dividing by how many numbers there are.

beginner

Write a formula to sum values in cells A1 to A5.

Use =SUM(A1:A5) to add all numbers from cell A1 through A5.

beginner

What happens if you use COUNT on a range with text and numbers?

COUNT only counts the cells with numbers. Text cells are ignored.

Which function adds all numbers in a range?

A COUNT

B SUM

C AVG

D MIN

SUM adds all numbers in the selected cells.

What does COUNT(A1:A10) do?

A Adds all numbers

B Counts all cells including text

C Counts only cells with numbers

D Calculates average

COUNT counts only cells that contain numbers.

How do you find the average of numbers in B1 to B5?

A =SUM(B1:B5)

B =COUNT(B1:B5)

C =AVG(B1:B5)

D =AVERAGE(B1:B5)

The correct function for average is AVERAGE, not AVG.

If cells A1=5, A2=empty, A3=10, what does COUNT(A1:A3) return?

A 2

B 0

C 1

D 3

COUNT counts only numbers, so it counts A1 and A3.

Which function would you use to add only numbers and ignore text?

A SUM

B COUNT

C AVERAGE

D COUNTA

SUM adds numbers and ignores text automatically.

Explain how to use SUM, COUNT, and AVERAGE functions in Google Sheets with examples.

Think about adding, counting numbers, and finding the average.

Describe what happens when COUNT is used on a range with numbers, text, and empty cells.

Focus on what COUNT includes and excludes.