HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
Google Sheets has many premade formulas, called 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 |