Summarizing excel formulas
SUM(range): Adds all the numbers in the specified range.
AVERAGE(range): Calculates the average (mean) of the numbers in the range.
MIN(range): Finds the smallest number in the range.
MAX(range): Finds the largest number in the range.
COUNT(range): Counts the number of cells in the range that contain numbers.
COUNTA(range): Counts the number of non-empty cells in the range.
SUBTOTAL(function_num, range): Performs a specified calculation (like SUM, AVERAGE) on a
filtered range.
COUNTIF(range, criteria): Counts the number of cells in a range that meet a single condition.
COUNTIFS(range1, criteria1, [range2, criteria2], ...): Counts the number of cells that meet multiple
conditions.
SUMIF(range, criteria, [sum_range]): Adds the cells specified by a condition or criteria.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...): Adds the cells
specified by multiple criteria.
AVERAGEIF(range, criteria, [average_range]): Calculates the average of the cells specified by a
condition.
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...): Calculates
the average of cells that meet multiple criteria
CONCATENATE(text1, [text2], ...) or TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...): Joins
multiple text strings into one.
LEFT(text, [num_chars]): Extracts the specified number of characters from the left side of a text
string.
RIGHT(text, [num_chars]): Extracts the specified number of characters from the right side of a text
string.
MID(text, start_num, num_chars): Extracts a specified number of characters from the middle of a
text string.
LEN(text): Returns the number of characters in a text string.
TRIM(text): Removes extra spaces from text, leaving only single spaces between words.
UPPER(text): Converts text to uppercase.
LOWER(text): Converts text to lowercase.
PROPER(text): Capitalizes the first letter of each word.
