EXCEL FUNCTIONS

=AVERAGE - (range)

=MIN - (number1, [number2]...)

=MAX - (number1, [number2]...)

=SUMPRODUCT - (array1, [array2], [array3]...)

=IF - (logical_test, value_if_true, value_if_false)

=AND - (logical1, [logical2]...)

=OR - (logical1, [logical2]...)

=MATCH - (lookup_value, lookup_array, [match_type])

=INDEX - (reference, row_num, [column_num], [area_num])

=VLOOKUP - (lookup_value, table_array, col_index_num, [range_lookup])

=XLOOKUP - (lookup_value, lookup_array, return_array)

=CONCATENATE - (text1, [text2]...)

=SUBSTITUTE - (text, old_text, new_text, [instance_num])

=COUNT - (value1, [value2]…)

=COUNTA - (value1, [value2]…)

=COUNTBLANK - (range)

=COUNTIF - (range, criteria)

=COUNTIFS - (criteria_range1, [criteria_range2]...)