The __ function is used to average a range of cells based on multiple conditions. Both the range of cells and the conditions must be specified. SUMIFS HLOOKUP VLOOKUP COUNTIFS AVERAGEIFS

## Step 1<br />The problem is asking us to identify the function in Microsoft Excel that is used to average a range of cells based on multiple conditions. The options provided are SUMIFS, HLOOKUP, VLOOKUP, COUNTIFS, and AVERAGEIFS.<br /><br />## Step 2<br />Let's analyze each function:<br /><br />### SUMIFS<br />This function is used to add the values in a range of cells, based on one or more conditions.<br /><br />### HLOOKUP<br />This function is used to search for a value in the first row of a table, and return a value in the same column from a specified row index.<br /><br />### VLOOKUP<br />This function is used to search for a value in the first column of a table, and return a value in the same row from a specified column index.<br /><br />### COUNTIFS<br />This function is used to count the number of cells that meet multiple conditions.<br /><br />### AVERAGEIFS<br />This function is used to average the values in a range of cells, based on multiple conditions.<br /><br />## Step 3<br />From the above analysis, it is clear that the function that fits the description given in the problem is AVERAGEIFS. This function is used to average the values in a range of cells, based on multiple conditions.