Google Sheets is one of the best alternatives to Excel . Personally, I have no doubt about that. If you’re also trying to switch to this tool and leave the Microsoft ecosystem, what I tell you here will be interesting. In the following sections, I explain the best formulas for Google Sheets . I also briefly explain how to enter them into cells, in case you’re just starting out in the world of spreadsheets. Here you’ll find all the information you need to get even more out of this Google application. Don’t miss it!
- How to put a formula in Google Sheets?
- The basic formulas for Google Sheets that you should know
- ADDITION
- AVERAGE
- COUNT
- MAX
- MIN
- YEAH
- CONCATENATE
- VLOOKUP
- NOW
- ROUND
- COUNTIF
- SUMIF
- CONCAT
- IMPORTXML
- TRANSPOSE
- UNIQUE
- FILTER
- SUMPRODUCT
- COUNT.A
- DAYS
- IMPORT RANGE
- COINCIDE
How to put a formula in Google Sheets?
Many Excel formulas work the same way in Google Sheets. In fact, the way you enter them into cells is the same. To write a formula, first select the cell where you want to enter it. Then, type the equal sign (=) .
It’s that easy to add a formula to Google Sheets. Just like in Excel.
You’ll quickly see a list of common formulas appear . After the equal sign (=), you can type the formula name or simply select it from the list. Entering new formulas into a Google spreadsheet is that easy.
The basic formulas for Google Sheets that you should know
ADDITION
The SUM formula is used to add a range of numbers. It’s one of the most basic and most used formulas in Google Sheets. This function is especially useful when you need to quickly sum a large number of values. Like the other formulas, the results update dynamically.
- Example : =SUM(A1:A10)
AVERAGE
The AVERAGE formula calculates the average, also known as taking the mean, of a set of values. It’s useful for finding the middle value of a data group.
- Example : =AVERAGE(B1:B10)
COUNT
The COUNT formula counts the number of cells that contain numbers within a specified range.
- Example : =COUNT(C1:C10)
MAX
The MAX formula returns the maximum value in a range of cells. It’s useful for finding the highest value in a data set. As the data changes, the cell with this formula updates to always reveal the highest value.
- Example : =MAX(D1:D10)
MIN
It does the opposite of the previous formula. That is, the MIN formula returns the minimum value in a range of cells. It’s useful for finding the lowest value in a data set. It also updates dynamically.
- Example : =MIN(E1:E10)
YEAH
The IF formula allows you to enter conditional statements in cells. For example, it allows you to obtain one value or another based on whether the condition is true or false. This is essential for rapid data analysis.
- Example : =IF(F1>10, “Greater than 10”, “Less than or equal to 10”)
CONCATENATE
The CONCATENATE formula joins multiple text values into a single cell. It’s useful for combining names, addresses, or other data from different locations in the spreadsheet. You can add spaces between the values by following the example below:
- Example : =CONCATENATE(G1, ” “, G2)
VLOOKUP
The VLOOKUP formula searches for a value in the first column of a range and returns a value in the same row from a specified column. It’s essential for searching data in large data tables.
- Example : =VLOOKUP(H1, A2:D10, 2, FALSE)
NOW
The NOW formula returns the current date and time. You can use it to mark records with the date and time the data was entered, as it updates every time the spreadsheet is accessed or new data is added.
- Example : =NOW()
ROUND
The ROUND formula rounds a number to a specific number of digits. It’s useful for adjusting numbers to a desired precision.
- Example : =ROUND(I1, 2)
COUNTIF
The COUNTIF formula counts the number of cells in a range that meet a specific criterion. It helps when you need to count data that meets certain conditions.
- Example : =COUNTIF(J1:J10, “>5”)
SUMIF
The SUMIF formula adds the cells in a range that meet a specified criterion. It’s used to add values based on conditions.
- Example : =SUMIF(K1:K10, “Sales”, L1:L10)
CONCAT
The CONCAT formula also combines text from multiple cells into a single cell. It’s similar to CONCATENATE but more flexible. For example, it supports cell ranges.
- Example : =CONCAT(M1, ” “, N1)
IMPORTXML
The IMPORTXML formula imports data from a URL in XML format. This is useful for extracting structured data from the web. The data is reloaded every time you open the spreadsheet.
- Example : =IMPORTXML(“https://example.com/data.xml”, “//element”)
TRANSPOSE
The TRANSPOSE formula changes the orientation of a range of cells from horizontal to vertical or vice versa. It will help you reorganize the data in your spreadsheet.
- Example :
=TRANSPONER(O1:O10)
UNIQUE
The UNIQUE formula returns a list of unique values in a range. It’s ideal for removing duplicates and displaying data that doesn’t occur more than once, i.e., is unique.
- Example : =UNIQUE(P1:P10)
FILTER
The FILTER formula returns a subset of a range that meets specific criteria. It allows you to extract filtered data from large sets quite easily. Remember, though, that Google Sheets already has a built-in filtering feature.
- Example : =FILTER(Q1:Q10, Q1:Q10>5)
SUMPRODUCT
The SUMPRODUCT formula returns the sum of the products of corresponding ranges or matrices. I recommend it if you’re looking for more advanced calculations.
- Example : =SUMPRODUCT(R1:R10, S1:S10)
COUNT.A
The COUNTA formula counts the number of non-empty cells in a range. It’s useful for counting any type of data, not just numbers.
- Example : =COUNTA(T1:T10)
DAYS
The DAYS formula returns the number of days between two dates. It’s useful for calculations involving duration.
- Example : =DAYS(“2024-12-31”, “2024-01-01”)
IMPORT RANGE
The IMPORTRANGE formula imports a range of cells from another Google Sheets spreadsheet. It’s essential for combining data from multiple sheets.
- Example : =IMPORTRANGE(“Sheet_URL”, “Sheet1!A1:B10”)
COINCIDE
The MATCH formula returns the relative position of an item in a range that matches a given value. This is useful for finding the location of a value in a range.
- Example : =MATCH(“Sale”, A1:A10, 0)

