Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

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