Google Sheets Formulas for Beginners: A Simple Guide

If you have ever manually added up a spreadsheet full of numbers on a calculator, you have felt the frustration Google Sheets formulas remove. A formula does the calculation for you, updates automatically when numbers change, and can be copied down hundreds of rows in seconds.

The barrier for most beginners is unfamiliar symbols. An equals sign, a colon, and a few brackets make a simple sum look like code. In reality, the formulas in this guide cover most of what students, freelancers, and office workers need every day, with real examples you can type as you read.

Quick Answer

Every Google Sheets formula starts with = followed by a function name and cell references, such as =SUM(A1:A10) to add a column or =AVERAGE(B2:B20) for an average. Type the formula in the cell where you want the answer, press Enter, and use the small blue square in the cell corner to copy it to other rows.

How Formulas Work: Cells, Ranges, and the Equals Sign

You need three basic ideas first. Every box is a cell, identified by column letter and row number: the top left is A1, to its right is B1, below it is A2. A range is a group written with a colon, so A1:A10 means A1 down to A10. Every formula must start with an equals sign; without it, Sheets treats your entry as plain text.

1. Open Google Sheets at sheets.google.com and click Blank spreadsheet to create a practice file.
2. In A1 type Item, in B1 type Price, and in C1 type Quantity as simple headings.
3. Fill in a few rows of example data, such as Notebook in A2 with 5 in B2 and 3 in C2, Pen in A3 with 2 in B3 and 10 in C3.
4. Click cell D1 and type Total, then click cell D2, type =B2*C2, and press Enter. Sheets multiplies the price by the quantity instantly.
5. Click D2 again, hover over the small blue square at the bottom right corner of the cell, and drag it down to D3. This fill handle copies the formula and automatically adjusts it to =B3*C3 for the next row.

That action — write once, drag to copy — is the foundation of spreadsheet efficiency. Find more walkthroughs in the NetworkUstad Google Workspace and productivity tutorials. Google also maintains a reference in its Google Sheets function list and formula help.

The Essential Maths Formulas: SUM, AVERAGE, MAX, MIN, and COUNT

These five functions answer the questions beginners ask most often: what is the total, what is typical, what is highest and lowest, and how many entries are there?

1. To add a column, click the cell below your numbers, for example B6 if your prices are in B2:B5, type =SUM(B2:B5), and press Enter.
2. To find the average, type =AVERAGE(B2:B5) in another cell. Sheets adds the values and divides by how many there are, ignoring empty cells.
3. To find the largest value, type =MAX(B2:B5), and for the smallest, type =MIN(B2:B5).
4. To count how many numbers you have, type =COUNT(B2:B5). To count entries of any kind, including text like names, use =COUNTA(A2:A5) instead.
5. Try changing one of the original prices and watch every result update automatically. That live updating is the real power of formulas over a calculator.

Everyday Logic With IF, and Counting With Conditions

Once basic maths feels comfortable, the IF function unlocks a new level, because it lets your spreadsheet make simple decisions. The pattern is =IF(test, value if true, value if false). In plain language: if something is true, show this, otherwise show that.

1. Suppose pass marks are 50 and student scores are in D2:D6. Click E2 and type =IF(D2>=50,”Pass”,”Fail”), then press Enter.
2. Drag the fill handle down to E6. Each student now has an automatic Pass or Fail result that updates if a score changes.
3. To count how many passed without counting manually, type =COUNTIF(E2:E6,”Pass”) in a summary cell.
4. To add up only certain values, for example total sales over 100 in range B2:B20, use =SUMIF(B2:B20,”>100″). For a more flexible version where the criteria is in another column, such as total quantity for only the item Pen in A2:A20 with quantities in C2:C20, use =SUMIF(A2:A20,”Pen”,C2:C20).

Text inside a formula, like “Pass”, must be in double quotes. If you get an error, check for a missing quote, comma, or closing bracket.

Text and Date Formulas You Will Actually Use

Not all data is numbers. Sheets includes simple text formulas that clean up messy lists, such as names typed in inconsistent capital letters or email lists split across columns.

1. If names in A2:A20 are typed in mixed case, type =PROPER(A2) in B2 to get a neatly capitalised version like Ahmed Khan, then drag it down the column.
2. To join a first name in A2 and a last name in B2 into one full name in C2, type =A2&” “&B2. The & symbol joins pieces of text, and ” ” adds the space between them.
3. To count the characters in a cell, for example to check a product code length, use =LEN(A2).
4. For today’s date that updates every day, type =TODAY() with empty brackets. To calculate days between a start date in A2 and today, type =TODAY()-A2.
5. To extract the year from a date in A2, use =YEAR(A2), and for the month name number, use =MONTH(A2).

These formulas save time when cleaning data from forms or online shops. Google also provides examples in its guide to using formulas and functions in Google Sheets.

Looking Up Values With VLOOKUP

VLOOKUP sounds advanced, but the idea is simple: find a value in the first column of a table and return information from another column in the same row. Think of a price list where you type a product code and Sheets finds its price for you.

1. Create a small price list on the same sheet or a second sheet tab. For example, put product codes in F2:F4 (P01, P02, P03) and their prices in G2:G4 (15, 25, 40).
2. Click the cell where you want the price to appear, for example H2, and type =VLOOKUP(“P02”,F2:G4,2,FALSE).
3. Read the formula in parts: “P02” is what to search for, F2:G4 is the table to search in, 2 means return the value from the second column of that table, and FALSE means find an exact match only.
4. Press Enter and Sheets returns 25, the price for P02. Change “P02” to a cell reference like =VLOOKUP(A2,F2:G4,2,FALSE) so you can drag the formula down for many rows at once, with each row looking up its own code from column A.
5. If you see #N/A, it means the code was not found. Check for extra spaces or a spelling difference between your search value and the table.

Lock the table range as $F$2:$G$4 with dollar signs so it does not shift when you drag the formula down. Pressing F4 adds those dollar signs automatically.

Fixing Common Formula Errors

Error codes tell you what to check. #DIV/0! means you divided by zero or an empty cell. #VALUE! means a formula expected a number but found text. #REF! means a referenced cell was deleted. #NAME? usually means a function name is misspelled, such as SUMM instead of SUM. Click the help icon next to any error for an explanation for that formula.

Common Mistakes and Tips

The most common beginner mistake is typing numbers as text. If a cell is left-aligned and SUM ignores it, the value was probably typed with a currency symbol in a strange format, pasted as text, or contains a hidden space. Retype it as a plain number and format the cell using Format > Number > Currency instead of typing symbols manually.

A second mistake is hard-coding totals. If you type =5+3+10 instead of =SUM(B2:B4), your answer will not update when the source numbers change, and nobody else can audit how you got the result. Always reference cells, not typed numbers, inside formulas wherever possible.

Label every summary result, use Format > Number for consistent decimals and currency, and freeze the header row with View > Freeze > 1 row on long lists.

Conclusion

Google Sheets formulas are short, logical instructions that start with an equals sign and answer one clear question about your data. Master SUM, AVERAGE, MAX, MIN, and COUNT first, add IF, COUNTIF, and SUMIF for decisions, and try VLOOKUP to pull information from a table. Practice on a small sheet, drag formulas instead of retyping them, and you will handle budgets, marksheets, and reports far faster than manual calculation allows.

Frequently Asked Questions

Why does my formula show as text instead of a result?

Your formula is probably missing the equals sign at the start, or the cell is formatted as plain text. Click the cell, make sure the entry begins with = and contains no space before it, go to Format > Number > Automatic, then press Enter again to calculate.

What is the difference between COUNT and COUNTA?

COUNT only counts cells that contain numbers, while COUNTA counts any non-empty cell, including text, dates, and numbers. Use COUNT for numeric data checks and COUNTA when you want to know how many names, entries, or responses you have in a list.

How do I copy a formula without the references changing?

Use dollar signs to lock a reference, such as $B$2 for a fixed cell or $F$2:$G$4 for a fixed table. A dollar sign before the column letter locks the column, before the row number locks the row, and before both locks the entire reference when you drag or copy the formula.

Can Google Sheets formulas work across different sheets?

Yes. Reference another tab by writing its name followed by an exclamation mark, for example =SUM(Sales!B2:B20) adds values from the Sales sheet. If the sheet name contains spaces, wrap it in single quotes like =’January Sales’!B2:B20 so Sheets reads it correctly.

Is Google Sheets similar to Microsoft Excel for formulas?

Very similar. Core functions like SUM, AVERAGE, IF, COUNTIF, and VLOOKUP work with nearly identical syntax in both programs, so skills learned in Sheets transfer directly to Excel. The main differences are in some advanced functions, add-ons, and how files are shared and stored.