![]() To find an average of numeric values in a given column if another column contains certain text, you build an AVERAGEIF formula with text criteria. How to use AVERAGEIF function in Excel - examplesĪnd now, let's see how you can use Excel AVERAGEIF in real-life worksheets to find an average of cells that meet your criteria. Where C3:C15 are the cells to check against the criteria and B3:B15 are the cells to average. To average based on another cell, you define all 3 arguments: range (cells to check against the condition), criteria (the condition) and average_range (cells to calculate).įor instance, to get an average of sales that were delivered after Oct-1, the formula is: For example, to find an average of sales in B3:B15 that are greater than $120, the formula is: ![]() In case the condition applies to the same column that should be averaged, you define only the first two arguments: range and criteria. With the Excel AVERAGEIF function, you can average a column of numbers based on: In other words, the upper left cell in average_range becomes the starting point, and as many columns and rows are averaged as contained in the range argument. However, the actual cells to be averaged are determined by the size of the range argument. The Average_range argument does not necessarily have to be of the same size as range.If no cell in range meets criteria, a #DIV/0! error is returned.If average_range contains only blank cells or text values, a #DIV/0! error occurs.If a criteria cell is empty, it is treated as a zero value (0). ![]() Zero values are included in the average.When calculating an average, empty cells, text values, and logical values TRUE and FALSE are ignored.To efficiently use the AVERAGEIF function in your worksheets, take notice of these key points: To average cells with two or more criteria, use the AVERAGEIFS function.
0 Comments
Leave a Reply. |