Google Sheets is a free, cloud-based tool provided by Google to create, edit, and collaborate on spreadsheets online. Whether for personal or professional use, it empowers teams to work together in real-time and achieve more.
Discover MoreThe `SUM` function adds up a series of numbers or a range of cells in Google Sheets. It's commonly used to calculate totals in a dataset.
This formula will sum all the values from cell A1 to A10.
The `AVERAGE` function calculates the mean value of a range of numbers in a dataset.
This formula calculates the average value of the numbers in cells B1 through B10.
The `IF` function performs a logical test and returns one value if the condition is true, and another if the condition is false.
This formula checks if the value in cell C1 is greater than 100. If true, it returns "Above 100"; if false, it returns "Below 100".
The `VLOOKUP` function searches for a value in the first column of a range and returns a value in the same row from another column.
This formula searches for the value in cell D2 within the range A2:B10, and returns the value in the second column of the range where the match is found.
The `CONCATENATE` function joins two or more strings of text into a single string.
This formula combines the text from cells E1 and F1 with a space in between.