If you’re spending way too much time doing things manually in Google Sheets, adding up columns with a calculator, copying and pasting text cell by cell, or sorting data by hand every time something changes, there’s a better way. Formulas are built to handle all of that for you, automatically.
The good news is you don’t need to be a spreadsheet wizard to use them. In this guide, we’ll walk through 10 of the most useful Google Sheets formulas in 2026, what they actually do, and how to use them right now. Whether you’re building a budget, managing a project tracker, or cleaning up imported data, these formulas will save you a serious amount of time.
How to Enter a Formula in Google Sheets
Before we jump in, here’s the quick version of how formulas work in Sheets, because the process is the same for every formula on this list.
- Click on any empty cell where you want the result to appear.
- Type
=followed by the formula name (for example,=SUM).
- As you type, Sheets will show autocomplete suggestions and a tooltip explaining the formula’s syntax, what goes inside the parentheses. This is super handy when you can’t remember the exact format.
- Press Tab or click the suggested formula to insert it, then fill in your arguments (the cell references or values you want the formula to work with).
- Press Enter to apply the formula and see your result.
To reference a cell, just type its column letter and row number, like B3 or A1:A10 for a range. You can also click and drag to select a range instead of typing it manually.
Pro tip: You can also go to Insert > Function to browse formulas grouped by category (Math, Lookup, Text, etc.) if you’re not sure what you’re looking for.
10 Google Sheets Formulas That Will Save You Time
These are the formulas that everyday Sheets users actually benefit from, not obscure functions you’ll use once and forget. Let’s get into it.
1. TODAY(), Stop Checking the Calendar
How many times a day do you glance at the corner of your screen to check the date? If you’re managing deadlines or tracking time-sensitive data in Sheets, the TODAY() function takes care of that automatically.
Just type =TODAY() into any cell and it will display today’s date. Every time you open the spreadsheet, it updates on its own, no manual changes needed.
This gets really powerful when you combine it with other formulas. For example, =A2-TODAY() will automatically calculate how many days are left until a deadline in cell A2. As days pass, the number counts down by itself.
Syntax: =TODAY() no arguments needed, just the empty parentheses.
2. COUNTIF(), Count Only What Matters
Sometimes you don’t want to count everything in a column, just the entries that meet a specific condition. That’s exactly what COUNTIF() is for. Think of it as a smarter version of counting that has a filter built in.
For example, say you have a survey where people listed how many cars they own. You want to know how many respondents own two or more. Instead of scanning through every row yourself, you can write:
=COUNTIF(B2:B50,">=2")
Sheets will count every cell in that range that meets the condition and give you the total instantly.
Syntax: =COUNTIF(range, criterion)
The criterion can be a number, a comparison like ">=2", or even a text value like "Yes". If you need to count based on multiple conditions at once, check out COUNTIFS() it works the same way but lets you stack conditions.
Related formulas worth knowing: SUMIF() adds values conditionally, and AVERAGEIF() finds the average of values that meet your criteria.
3. SUM(), Add It All Up Without a Calculator
This one is probably the most-used formula in all of Google Sheets, and for good reason. SUM() adds together all the numbers in a range of cells, instantly, and without any math on your part.
=SUM(A2:A20)
The real magic is that it updates automatically. Changes within A2:A20 update the total. Values added outside that range are not included unless you expand the reference.
Syntax: =SUM(value1, value2, ...) or =SUM(A2:A20) for a range
Building a budget? Tracking sales totals? Tallying up hours worked? SUM() is going to be your best friend. It works with positive numbers, negative numbers, and zeros.
Want more control? Try SUMIF() or SUMIFS() to only add values that meet certain conditions, like summing sales from a specific region or product category.
4. CONCATENATE(), Combine Text from Multiple Cells
Here’s a common scenario: you have a spreadsheet with first names in one column and last names in another, but you need a single “Full Name” column. Copying and pasting each one by hand would take forever. CONCATENATE() handles it in seconds.
Concatenate is just a fancy word for “join together.” The formula lets you combine text from multiple cells into one.
=CONCATENATE(A2," ",B2)
That formula would combine the first name in A2, a space, and the last name in B2, giving you “Jane Smith” as the result.
Syntax: =CONCATENATE(string1, string2, ...)
You can include as many pieces as you want, including literal text in quotes (like that space between names, or a comma, or any other character). This is great for building personalized messages, creating unique IDs, or merging address fields. For more ways to work with text in Sheets, check out these Google Sheets text functions.
5. TRIM(), Clean Up Messy Spacing
Anyone who’s ever pasted data into Sheets from another source knows the pain of weird spacing. Extra spaces before words, double spaces between them, trailing spaces at the end, they’re invisible but they cause all kinds of problems with sorting, searching, and matching data.
TRIM() removes extra ordinary spaces and leaves one between words. Unusual whitespace from imported text may need separate cleanup.
=TRIM(A2)
Syntax: =TRIM(text)
This is especially useful if your sheet collects form responses or data imported from another system. It’s a quick, painless way to clean things up before you run any other formulas on the data.
Heads up: If you want to clean up data in place (not in a separate column), you can also use Data > Data cleanup > Trim whitespace, a built-in tool that does the same thing without a formula.
6. TEXT(), Format Numbers and Dates the Way You Want
Google Sheets sometimes makes its own decisions about how to display a value, turning a number into a date, dropping decimal places, or showing a dollar amount without the $ sign. The TEXT() function lets you take control of that formatting.
It converts a value into text displayed in whatever format you specify. This is particularly useful when you want to combine a number or date with regular text in the same cell.
=TEXT(A2,"$#,##0.00") → Displays the number in A2 as a dollar amount, like $1,250.00
=TEXT(TODAY(),"MMMM DD, YYYY") → Displays today’s date using a spelled-out month, two-digit day, and four-digit year
Syntax: =TEXT(value, format_pattern)
The format pattern goes in quotes and uses standard number/date formatting codes. Common ones include "$#,##0.00" for currency, "0%" for percentages, and "MM/DD/YYYY" for dates. For a full reference of supported format patterns, Google’s official format codes list is a handy bookmark.
7. GOOGLETRANSLATE(), Translate Text Without Leaving Sheets
This one is genuinely impressive. If you work with international teams or multilingual data, GOOGLETRANSLATE() lets you translate text directly inside your spreadsheet, no copying to Google Translate and back.
You can translate a whole column of phrases from English into Spanish, French, Japanese, or dozens of other languages, all at once.
=GOOGLETRANSLATE(A2,"en","es")
That formula takes the text in A2, tells Sheets it’s in English (“en”), and translates it to Spanish (“es”).
Syntax: =GOOGLETRANSLATE(text, source_language, target_language)
Not sure what language a piece of text is in? Set the source language to "auto" and Sheets will figure it out:
=GOOGLETRANSLATE(A2,"auto","en")
This is powered by Google’s translation engine, so the quality is solid for most common languages.
8. SORT(), Keep Your Data Automatically Sorted
Manually sorting a list every time new data gets added is one of those tedious tasks that eats up way more time than it should. The SORT() formula fixes that by automatically generating a sorted version of your data in a separate area of the sheet.
=SORT(A2:B20, 1, TRUE)
That formula sorts the data in A2:B20 by the first column in ascending order (A to Z, or smallest to largest). Change TRUE to FALSE for descending order.
Syntax: =SORT(range, sort_column, is_ascending)
The sorted output updates automatically whenever the source data changes, so you never have to re-sort manually again. Just make sure the area where the sorted results appear is empty, or you’ll get an error. You can also combine this with filtering in Google Sheets for even more control over your data view.
9. TRANSPOSE(), Flip Rows and Columns Instantly
Ever set up a spreadsheet and then realized your rows should be columns and your columns should be rows? Or maybe a colleague sent you data that’s laid out horizontally when you need it vertically? TRANSPOSE() flips everything around in one step.
=TRANSPOSE(A1:D5)
Syntax: =TRANSPOSE(array_or_range)
The rows become columns, the columns become rows, and all the data moves to the right place automatically. And just like SORT(), the transposed result updates dynamically when the original data changes.
Again, make sure the destination area is empty before running this. If there’s existing data where the transposed result would land, Sheets will throw a #REF! error.
10. AVERAGE(), Find the Mean Without the Math
The AVERAGE() function does exactly what it sounds like, it calculates the average (also called the mean) of a set of numbers. That means it adds them all up and divides by how many there are, so you don’t have to.
=AVERAGE(B2:B20)
Syntax: =AVERAGE(value1, value2, ...) or =AVERAGE(B2:B20) for a range
This is useful for everything from calculating a student’s grade average to finding the average monthly revenue in a financial report. Need to average only values that meet a condition? Try AVERAGEIF() same idea as COUNTIF() but for averages.
Bonus: Two Modern Formulas Worth Knowing in 2026
Google has been steadily adding new functions to Sheets, and two recent additions are genuinely useful if you work with multi-tab spreadsheets.
- SHEET(): Returns the sheet number of a given tab. Type
=SHEET()to get the current sheet’s number, or=SHEET("Budget")to get the number of a specific sheet by name. Handy for building dynamic references across tabs.
- SHEETS(): Returns the total number of sheets in your spreadsheet. Useful for dashboards or workbooks where you’re dynamically referencing data across multiple tabs.
These won’t come up for everyone, but if you’re managing a complex multi-tab workbook, they’re worth bookmarking.
Tips and Troubleshooting
Common Issues
Problem: My formula is showing an error instead of a result
A few things to check:
- Make sure every opening parenthesis has a matching closing parenthesis.
- Check that you’re using commas to separate arguments, some regional settings use semicolons, which can cause issues.
- If you’re seeing
#REF!, the formula is trying to output results into cells that already have data. Clear the destination area first.
- If numbers are imported from another source and look right but aren’t calculating, they might be stored as text. Try wrapping them in
VALUE()like=VALUE(A2)to convert them to actual numbers.
If you keep running into formula errors, our guide on how to fix Google Sheets formula parse errors walks through the most common causes and solutions.
Problem: My formula result isn’t updating when I change the data
Go to File > Settings and check the Calculation tab. Make sure recalculation is set to On change or On change and every minute.
Problem: My SORT() or TRANSPOSE() formula is throwing an error
These formulas output results into multiple cells (called “spilling”). If any of those cells already have content, you’ll get an error. Clear out the destination area completely and try again.
Pro Tips
- Limit your ranges for better performance: Using
A:A(the entire column) in a formula works, but it can slow things down on large sheets. Use a specific range likeA2:A1000instead when you can.
- Use absolute references when copying formulas: If you copy a formula to other cells and the cell references shift in a way you don’t want, add
$signs to lock them, like$A$2instead ofA2. That tells Sheets not to adjust that reference when the formula is copied.
- Discover formulas with Insert > Function: If you’re not sure what’s available, browse by category here. It’s a great way to stumble onto something useful you didn’t know existed. You can also explore hidden Google Sheets features that most users overlook.
Start Saving Time in Google Sheets
Once you start using these formulas regularly, you’ll wonder how you ever managed without them. Even just SUM(), TODAY(), and TRIM() alone can cut out a surprising amount of repetitive manual work. The features in this guide apply to the current web version of Google Sheets and recent versions of the Android and iOS apps, so you can use them wherever you work.
Honestly, the hardest part is just remembering to reach for a formula instead of doing things by hand, so bookmark this page for reference. Got a favorite formula we didn’t cover? Drop it in the comments below.