In this example, one range of cells is evaluated against the criteria and a second range of cells is averaged. Now we’ll use the AVERAGEIF function to determine the average for sales where the number of orders is greater than 50. ![]() ![]() The function evaluates how many cells in the Sales column meet the criteria of greater than 60000. The average for sales greater than $60000 is $71229. Excel automatically adds the closing parenthesis to the formula. Excel would interpret that as a separator for arguments of the function and return an error.Īnd press Enter. ![]() Type an = sign, AVERAGEIF, opening parenthesis (in this example, we are going to evaluate and average the same range of cells, C2 through C5, in the Sales column), comma, then we type the criteria against which the range is evaluated, enclosed in quotes (you put it in quotes so Excel interprets the operator and value correctly), in this example, greater than 60000.ĭon’t type a comma in 60000. Let’s determine the average for sales that are greater than $60000. The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |