How to Use Formulas in Google Sheets: Simple Guide

In Google Sheets, you use = to start a formula, followed by functions or operations like =SUM(A1:A5). Formulas calculate values dynamically based on cell data and update automatically when data changes.

Syntax

Formulas in Google Sheets always start with an = sign. After that, you can use functions, cell references, numbers, and operators.

• =: tells Google Sheets you are entering a formula.
• Function: a predefined operation like SUM or AVERAGE.
• Cell references: point to cells like A1 or ranges like A1:A5.
• Operators: symbols like +, -, *, / for math.

plaintext

=SUM(A1:A5)

Example

This example adds numbers in cells A1 through A5 and shows the total in cell A6.

plaintext

A1: 10
A2: 20
A3: 30
A4: 40
A5: 50
A6: =SUM(A1:A5)

Output

A6: 150

Common Pitfalls

Common mistakes include forgetting the = sign, using incorrect cell references, or mixing text with numbers without quotes.

For example, writing SUM(A1:A5) without = will not work.

plaintext

Wrong: SUM(A1:A5)
Right: =SUM(A1:A5)

Quick Reference

Formula Part	Description	Example
=	Starts a formula	=A1+B1
SUM	Adds numbers in a range	=SUM(A1:A5)
AVERAGE	Calculates average	=AVERAGE(B1:B5)
Cell Reference	Points to a cell	=A1
Operators	Math symbols	=A1*2

Key Takeaways

Always start formulas with an equals sign (=) in Google Sheets.

Use cell references and functions like SUM to calculate values dynamically.

Check for common errors like missing = or wrong cell references.

Formulas update automatically when you change the data in referenced cells.