Google Sheets Functions
Google Sheets has many premade formulas, called functions.
Functions are typed by
= and the functions name.
Once you have typed the function name you need to apply it to a range.
The range is always inside of parentheses.
|=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|