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.
Lookup and Range Functions
Lookup and Range Functions fetches data from one location to another based on one or many criteria.
IFERROR Function
Returns the second argument if the first argument contains an error. Returns the first argument if no error is found.
IF Function
Returns second argument if the condition is met else it returns third argument.
NOT Function
Returns TRUE if the argument is FALSE and FALSE if the argument is TRUE.
XOR Function
Returns TRUE if an odd number of arguments are TRUE.