Formulas Part 3

Cell Addresses

=ROW()
=COLUMN()
=ADDRESS(H5, I5) Absolute
=ADDRESS(H5, I5, 4) Relative
=INDIRECT()
=OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
=INDEX(Range, row, column)

Lookups & matching

=VLOOKUP(search_key, range, index, [is_sorted])
=SORT(range, sort_column, is_ascending, [sort_column2, ...], [is_ascending2, ...])
=MATCH(search_key, range, [search_type])

=UNIQUE(Range)
=COUNTIF(Range,value)
=COUNTIFS(Range1, value1, Range2, value2...)
=SUMIF(Range1, value1 in Range1, Range2) = Sum of values coresponding to value1 in Range2
=AVERAGEIF(Range1, value1 in Range1, Range2) = Average of values coresponding to value1 in Range2