Function | Meaning |
SUM | Adds up a range of numbers and returns the sum |
AVERAGE | Calculates the average of a range of numbers |
IF | Performs a logical test and returns different values based on the result |
VLOOKUP | Searches for a value in the leftmost column of a table and returns a corresponding value from a specified column |
COUNT | Counts the number of cells in a range that contain numbers |
AVERAGE: | Computes the average of a range of values. |
COUNTIF | Counts the number of cells within a range that meet specific criteria. |
CONCATENATE | Joins together multiple text strings into one |