Table of Contents
Google Sheets is a powerful online spreadsheet tool that offers a wide range of functions to help users organize, analyze, and manipulate data. These functions include basic arithmetic operations such as addition, subtraction, multiplication, and division, as well as more advanced functions like SUMIF, COUNTIF, and AVERAGEIF, which allow users to perform calculations based on specific criteria. Additionally, Google Sheets offers functions for formatting data, creating charts and graphs, and importing data from external sources. With its extensive library of functions, Google Sheets provides users with the tools they need to efficiently manage and manipulate data for various purposes.
Google Sheets Functions
Functions
Google Sheets has many premade formulas, called functions.
Functions are typed by = and the functions name.
For example =SUM
Once you have typed the function name you need to apply it to a range.
For example =SUM(A1:A5)
The range is always inside of parentheses.
| Function | Description |
|---|---|
| =AND | Returns TRUE or FALSE based on two or more conditions |
| =AVERAGE | Calculates the average (arithmetic mean) |
| =AVERAGEIF | Calculates the average of a range based on a TRUE or FALSE condition |
| =AVERAGEIFS | Calculates the average of a range based on one ore more TRUE/FALSE conditions |
| =COUNT | Counts cells with numbers in a range |
| =COUNTA | Counts all cells in a range that has values, both numbers and letters |
| =COUNTBLANK | Counts blank cells in a range |
| =COUNTIF | Counts cells as specified |
| =COUNTIFS | Counts cells in a range based on one or more TRUE or FALSE condition |
| =IF | Returns values based on a TRUE or FALSE condition |
| =IFS | Returns values based on one or more TRUE or FALSE conditions |
| =MAX | Returns the highest value in a range |
| =MEDIAN | Returns the middle value in the data |
| =MIN | Returns the lowest value in a range |
| =MODE | Finds the number seen most times. The function always returns a single number |
| =OR | Returns TRUE or FALSE based on two or more conditions |
| =STDEV.P | Calculates the Standard Deviation (Std) for the entire population |
| =STDEV.S | Calculates the Standard Deviation (Std) for a sample |
| =SUM | Adds together numbers in a range |
| =SUMIF | Calculates the sum of values in a range based on a TRUE or FALSE condition |
| =SUMIFS | Calculates the sum of a range based on one or more TRUE or FALSE condition |
| =VLOOKUP | Allows vertical searches for values in a table |
| =XOR | Returns TRUE or FALSE based on two or more conditions |
Cite this article
stats writer (2024). What are the functions available in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/what-are-the-functions-available-in-google-sheets/
stats writer. "What are the functions available in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/what-are-the-functions-available-in-google-sheets/.
stats writer. "What are the functions available in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/what-are-the-functions-available-in-google-sheets/.
stats writer (2024) 'What are the functions available in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/what-are-the-functions-available-in-google-sheets/.
[1] stats writer, "What are the functions available in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. What are the functions available in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.