{"id":1366,"date":"2018-07-04T10:41:37","date_gmt":"2018-07-04T10:41:37","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1366"},"modified":"2023-11-02T19:13:46","modified_gmt":"2023-11-02T19:13:46","slug":"averageif","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/averageif\/","title":{"rendered":"AVERAGEIF function"},"content":{"rendered":"\n
The AVERAGEIF function in Excel is a useful tool for finding the average of a range of numbers that meet a specific condition. It allows you to specify a criterion and calculate the average of only those numbers that satisfy that condition.<\/p>\n\n\n\n
AVERAGEIF(range, criteria, [average_range])<\/strong><\/p>\n\n\n\n Here’s how to use the AVERAGEIF function with examples:<\/p>\n\n\n\n Example 1:<\/strong> Find the average of test scores that are greater than 80 in the range A1:A10.<\/p>\n\n\n\n Example 2:<\/strong> Calculate the average of sales in the “West” region from the range A1:A20, where column B contains the region names.<\/p>\n\n\n\n Example 3:<\/strong> Compute the average of values in the range C1:C15, which corresponds to dates falling in the month of January.<\/p>\n\n\n\n Example 4:<\/strong> To find the average of all values that are not empty in the range D1:D30.<\/p>\n\n\n\n The AVERAGEIF function is a powerful tool to quickly calculate averages based on specific criteria, making it an essential part of Excel’s functionality for data analysis.<\/p>\n","protected":false},"excerpt":{"rendered":" The AVERAGEIF function in Excel is a useful tool for finding the average of a range of numbers that meet a specific condition….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
range<\/strong><\/td> The range of cells to be evaluated against the given criteria.<\/td><\/tr> criteria<\/strong><\/td> The condition that determines which cells in the range are included in the average. You can use logical operators (e.g., “>, <, =”) or expressions (e.g., “>5”, “Red”).<\/td><\/tr> [average_range]<\/strong><\/td> (Optional) The range of cells containing the numbers to be averaged. If not provided, the function uses the “range” for averaging.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
=AVERAGEIF(A1:A10, \">80\")<\/code><\/pre>\n\n\n\n
=AVERAGEIF(B1:B20, \"West\", A1:A20)<\/code><\/pre>\n\n\n\n
=AVERAGEIF(C1:C15, \">=01\/01\/2023\", C1:C15)<\/code><\/pre>\n\n\n\n
=AVERAGEIF(D1:D30, \"<>\", D1:D30)<\/code><\/pre>\n\n\n\n