AVERAGEIF Function

Returns the average of a range of numbers that meet a given criteria
Sample Usage
AVERAGEIF([First Results]1:Data25, >25)
Syntax
AVERAGEIF(
  • range
  • criterion
  • [
    average_range
    ]
)
  • 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
Examples

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community