# 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 |