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 kommentar(er)
