Relacionar Columnas Advanced FunctionsVersión en línea match the Function with it's correct description. por Shari Black 1 SUMIFS 2 COUNTIFS 3 VLOOKUP 4 IF Function 5 HLOOKUP 6 SUMIF 7 AVERAGEIF 8 AVERAGEIFS 9 COUNTIF Searches for a value in the top row (horizontal) of Table_array and returns a value in the same column from Row_index_num. Adds the cells in a Sum_range that meet multiple Criteria. Counts the number of cells within multiple criteria_range# that meet criteria#. Searches for a value in the first column (vertical) of Table_array and returns a value in the same row from Col_index_num. Sets up a conditional statement to test data. The value returned depends on whether the condition is true or false. Returns the mean of cells in Average_range that meet multiple criteria. Adds the cells in a Range specified by a given criteria. Counts the number of cells within Range that meet the criteria. Returns the arithmetic mean of cells in Range or Average_range that meet a criteria.
Crear