The SUM function
=SUM(A1:A10)
Used to add up the values in a range of cells
The AVERAGE function
=AVERAGE(A1:A10)
Used to calculate the average of the values in a range of cells
The COUNT function
=COUNT(A1:A10)
used to count the number of cells in a range that contain numeric values
The COUNTA function
=COUNTA(A1:A10)
used to count the number of cells in a range that contain any type of value, including text, numbers, and formulas
The MAX & MIN function
=MAX(A1:A10)
=MIN(A1:A10)
used to return the highest or lowest value in a range of cells respectively
The IF function
=IF(A1>10,"Yes","No")
allows you to create conditional logic in your formulas
The VLOOKUP function
=VLOOKUP(10,A1:B10,2)
function searches for a value in a table and returns the corresponding value from another column in the table
The SUMIF function
=SUMIF(A1:A10,">10")
function sums the values in a range of cells that meet a certain criteria
The COUNTIF function
=COUNTIF(A1:A10,">10")
function counts the number of cells in a range that meet a certain criteria