Relier Pairs Advanced FunctionsVersion en ligne match the Function with it's correct description. par Shari Black 1 AVERAGEIF 2 IF Function 3 COUNTIFS 4 COUNTIF 5 SUMIF 6 HLOOKUP 7 AVERAGEIFS 8 VLOOKUP 9 SUMIFS Searches for a value in the first column (vertical) of Table_array and returns a value in the same row from Col_index_num. Adds the cells in a Range specified by a given criteria. 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#. Sets up a conditional statement to test data. The value returned depends on whether the condition is true or false. 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. Returns the mean of cells in Average_range that meet multiple criteria.