COUNTIFS Function
Returns a count of the number of rows that matches the criteria in criteria ranges.
SUMIFS Function
Returns sum of all values in the sum range for the rows that matches the criteria in criteria ranges.
VLOOKUP Function
Returns the value from the defined column and from the same row as the first match between lookup value and the leftmost column.
OFFSET Function
Returns the value from a cell that is a certain number of rows and columns from the reference cell.
MATCH Function
Returns the array position index of the first value in the array that matches the lookup value.