SUM: =SUM(number1, number2, …)
AVERAGE: =AVERAGE(number1, number2, …)
COUNT: =COUNT(value1, value2, …)
MAX: =MAX(number1, number2, …)
MIN: =MIN(number1, number2, …)
CONCATENATE: =CONCATENATE(text1, text2, …)
IF: =IF(condition, valueiftrue, valueiffalse)
VLOOKUP: =VLOOKUP(lookupvalue, tablearray, colindexnum, [range_lookup])
INDEX: =INDEX(array, rownum, [columnnum])
MATCH: =MATCH(lookupvalue, lookuparray, [match_type])