Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
There is a moment most spreadsheet beginners know well. You open Google Sheets, type a few numbers, and then you stare at a sea of empty cells wondering how anyone turns this into something useful. The words “formula” sounds like math class, and math class was never anybody’s favorite.
Here is the good news: you do not need ten years of math. You need about ten formulas, and most of them are simpler than sending a text message. Once you know them, a spreadsheet stops being a blank grid and starts feeling like a calculator that never gets tired.
This guide covers the ten google sheets formulas for beginners that deliver the most value for the least effort. Each one comes with a plain-English explanation and an example you can try right now. Open a fresh sheet and follow along — it will make much more sense once your fingers do the typing.
One quick thing before we start: every formula begins with an equals sign (=). That symbol tells the sheet “calculate this.” Type a formula into a cell, and the answer appears. Click the cell again and you will see the formula hiding behind the answer. That is the whole mystery.
Start With the One Everybody Needs
If you learn only one formula today, make it SUM. It adds up a range of numbers, and it is the single most-used formula in the entire history of spreadsheets. Imagine you have monthly expenses in cells B2 through B13, one row per month. Instead of pulling out a calculator twelve times, you click an empty cell and type:
=SUM(B2:B13)
Press Enter, and the total appears like magic. The colon between B2 and B13 means “everything from B2 down to B13.” You can also add up numbers that are not next to each other by listing them with commas, like =SUM(B2,B5,B9). Once you see it work on your own numbers, you will wonder why you ever added things by hand.
Try it now: put a few made-up numbers in a column and type a SUM formula below them. Change any number and the total updates instantly. That automatic updating is the whole point of spreadsheets.
Average Things Out Without a Calculator
The AVERAGE formula does exactly what the name says. If you track your weekly spending, your test scores, or the hours you sleep each night, AVERAGE tells you the typical value in one move:
=AVERAGE(C2:C31)
It works just like SUM but divides the total by how many numbers there are — perfect for “what do I usually spend on groceries?” Empty cells are ignored, so gaps in your data do not break the math.
COUNT, MIN and MAX: the Simple Trio
COUNT tells you how many cells contain numbers: =COUNT(D2:D100) on a sales list shows how many days you recorded.
MIN and MAX find the smallest and largest values. =MIN(D2:D100) shows your slowest day; =MAX(D2:D100) shows your best. Together with SUM and AVERAGE, these five formulas handle an enormous share of everyday tasks.
The Formula That Thinks: IF
IF is the first formula that feels a little bit like programming, and it is also the one that makes people fall in love with spreadsheets. It asks a yes-or-no question about a cell and does one thing for “yes” and another for “no.” The pattern is always the same:
=IF(something is true, “do this”, “otherwise do this”)
A real example: suppose cell E2 holds a student’s test score, and you want to show “Pass” or “Fail.” You write:
=IF(E2>=50, “Pass”, “Fail”)
If the score is 50 or higher, the cell shows Pass; otherwise it shows Fail. You can use numbers too: =IF(F2>1000, F2*0.1, 0) pays a ten percent bonus on sales over 1,000. The comparison symbols are simple: = equals, > greater than, < less than, >= or <= including the equal case. Nesting an IF inside another one handles three or more outcomes — worth trying once the basic version clicks.
Finding Things in Long Lists
VLOOKUP searches the first column of a range for a value, then returns a value from the same row in a column you choose — like looking up a word in a dictionary and reading the definition beside it.
Imagine a price list where column A has product codes and column B has prices. Type a code in H2, then in another cell write:
=VLOOKUP(H2, A2:B500, 2, FALSE)
Reading left to right: look up H2, search the first column of A2:B500, return the value from column 2, and FALSE means “find an exact match.” The sheet scans the product codes, finds your match, and hands back the price from the same row.
Two tips save a lot of confusion. First, the search value must sit in the leftmost column — VLOOKUP only looks to the right, never to the left. Second, use FALSE (exact match): it fails loudly if the value is missing, which is far better than quietly returning the wrong answer.
Putting Words Together and Stamping Dates
CONCATENATE joins text from multiple cells. If A2 holds a first name and B2 a last name, =CONCATENATE(A2, ” “, B2) combines them with a space. The ampersand is a handy shortcut: =A2&” “&B2 does the same thing. The quotes with a space inside (” “) insert a literal space. You will use this for full addresses, file names, and sentences built from data.
TODAY is the simplest formula on this list — it takes no arguments at all:
=TODAY()
It puts the current date in the cell and updates itself daily — handy for headers (“Report as of”) or stamping a log. Subtract a start date from it (=TODAY()-G2) and you get the days since, automatically staying correct.
Counting With Conditions
You already met COUNT, which counts every number in a range. COUNTIF is its smarter sibling: it counts only the cells that meet a condition you set. The pattern is =COUNTIF(range, “criteria”).
Say column H contains survey answers, some of which say “Yes.” To count how many people said yes, write:
=COUNTIF(H2:H200, “Yes”)
Criteria can be a number, a comparison, or text. =COUNTIF(I2:I50, “>100”) counts values above 100. =COUNTIF(J2:J50, “<>“) counts non-empty cells. Handy for attendance lists, feedback forms, or inventory — any tally of one kind of answer.
Need two conditions at once — “count the yes answers in the morning group”? That is COUNTIFS, the plural version, which accepts multiple range-and-criteria pairs. Not needed on day one, but good to know it is waiting.
Making Formulas Easier to Read and Reuse
Once you have a few formulas working, three habits will keep your sheets clean and your life easier. First, click any cell containing a formula and look at the formula bar at the top — that is the real home of your formula, and editing it there is much safer than retyping in the cell.
Second, learn the dollar-sign trick. When you copy a formula down a column, references shift automatically — usually what you want. But if a formula points to a fixed value, like a tax rate in K1, write $K$1 to lock it in place so it never moves. K$1 locks only the row; $K1 locks only the column.
Third, read errors calmly. #DIV/0! means you divided by zero or an empty cell. #N/A usually means VLOOKUP could not find your value. #VALUE! means text landed where numbers were expected. The sheet is telling you exactly what to fix.
Quick Answers Before You Start
Do formulas work the same in the Google Sheets phone app? Yes — the functions are identical. Long formulas are more comfortable on a computer, but checking and tweaking on the go works fine.
What happens if I delete a row my formula points to? Google Sheets usually adjusts your formulas automatically, shifting the range to skip the deleted row. If the deleted cell was the only input, you may see an error — that is your cue to point the formula at the right cells again.
Can formulas break if I sort my data? Sorting rows moves the data but the formulas move with their rows, so totals and lookups generally stay correct. VLOOKUP results follow the lookup value, not the row position, which is exactly the behavior you want after a sort.
Is there a limit to how many formulas I can use? For personal and small-business sheets, you will never hit it. Sheets handles thousands of formulas; performance only matters with truly enormous models, far beyond beginner territory.
Your Turn at the Keyboard
Ten formulas and one afternoon of practice, and you are no longer a spreadsheet beginner. Start with SUM and AVERAGE on your own numbers today, add IF tomorrow, and try VLOOKUP on a real list by week’s end. Each one builds on the last, and every success makes the next one less intimidating.
The real secret is that even people who use spreadsheets every day mostly reach for these same ten formulas. Experts know more, but they rarely need more. So open a fresh sheet, type that first equals sign, and see what happens. Your numbers have been waiting for someone to ask them questions — now you know how.
