Aug 22, 2024
=AVERAGE(range)
=AVERAGE(15, 27, 42, 93, 56, 84, 75, 33, 49)
=AVERAGE(100, 200)
→ Result: 150=AVERAGE(100, 200, 300)
→ Result: 200=SUM(range)
=SUM(range of numbers)
→ Result: 429=SUM(50, 125)
or =50 + 125
→ Result: 175=SUM(100, 200, 300)
→ Result: 600=SUMIF(range, criteria, sum_range)
=SUMIF(car_type_range, "Mazda", sum_range)
→ Result: 692=COUNT(range)
=COUNTA(range)
=COUNTBLANK(range)
=COUNTIF(range, criteria)
=CONCATENATE(text1, text2)
=CONCATENATE(B2, " ", C2)
→ Adds a space between the names.=IF(logical_test, value_if_true, value_if_false)
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])