Value aggregation (SUM, COUNT, AVG) in Google Sheets - Step-by-Step Guide

Introduction

Value aggregation helps you add up numbers, count items, or find the average in a list. This is useful when you want quick totals, counts, or averages without doing math by hand.

When you want to add all sales amounts in a column to see total sales.

When you need to count how many products are listed in your inventory.

When you want to find the average score of students in a test.

When you want to quickly see how many entries have numbers in a list.

When you want to summarize expenses by adding them up.

Steps

Step 1: Click

- a blank cell where you want the result

The cell is selected and ready for typing

Step 2: Type

- the formula bar

The formula appears in the selected cell

💡 Start formulas with an equal sign (=)

Step 3: Type

- formula bar

Formula is ready to calculate

💡 Use =SUM(range) to add numbers, =COUNT(range) to count numbers, =AVERAGE(range) to find average

Step 4: Select

- the range of cells with numbers (e.g., A1:A10)

The range is included in the formula

Step 5: Press

- Enter key

The cell shows the calculated total, count, or average

Before vs After

Before

Column A has numbers 10, 20, 30, 40, 50 in cells A1 to A5; cell B1 is empty

After

Cell B1 shows 150 after typing =SUM(A1:A5) and pressing Enter

Settings Reference

Range selection

📍 Inside the formula parentheses

Defines which cells to include in the calculation

Default: None

Function type

📍 Formula name at start (SUM, COUNT, AVERAGE)

Chooses the type of aggregation to perform

Default: SUM

Common Mistakes

Typing the formula without the equal sign, like SUM(A1:A5)

Google Sheets treats it as text, not a formula, so no calculation happens

Always start formulas with an equal sign, like =SUM(A1:A5)

Selecting cells with text when using SUM

SUM ignores text, so the total may be less than expected

Make sure the selected range contains only numbers for SUM

Using COUNT to count all cells including empty or text cells

COUNT only counts cells with numbers, so text or empty cells are ignored

Use COUNTA to count all non-empty cells including text

Summary

Value aggregation formulas add, count, or average numbers in a range.

Use =SUM(range) to add, =COUNT(range) to count numbers, and =AVERAGE(range) to find the average.

Always start formulas with an equal sign and select the correct range of cells.