- range—The range of cells to evaluate for the specified condition
- criterion—The condition that defines which numbers to add (for example: 15, “Hello World!”, >25)
- average_range—[optional]The range of cells to average
This example references the following sheet information:
Given the table above, here are some examples of using AVERAGEIF in a sheet:
|=AVERAGEIF(Customer:Customer, "Joe", [Quantity Ordered]:[Quantity Ordered])||Averages the values in the "Quantity Ordered" column, but only for the rows where the "Customer" is "Joe".||9|
|=AVERAGEIF(Item:Item, "Shirt", [Quantity Ordered]:[Quantity Ordered])||Averages the values in the "Quantity Ordered" column, but only for the rows where the "Item" is "Shirt".||15|
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.