# Excel.AggregationFunction enum

Aggregation Function for the Data Pivot Field.

### In this article

## Fields

automatic = "Automatic" | Excel will automatically select the aggregation based on the data items. |

average = "Average" | Aggregate using the average of the data, equivalent to the AVERAGE function. |

count = "Count" | Aggregate using the count of items in the data, equivalent to the COUNTA function. |

count |
Aggregate using the count of numbers in the data, equivalent to the COUNT function. |

max = "Max" | Aggregate using the maximum value of the data, equivalent to the MAX function. |

min = "Min" | Aggregate using the minimum value of the data, equivalent to the MIN function. |

product = "Product" | Aggregate using the product of the data, equivalent to the PRODUCT function. |

standard |
Aggregate using the standard deviation of the data, equivalent to the STDEV function. |

standard |
Aggregate using the standard deviation of the data, equivalent to the STDEVP function. |

sum = "Sum" | Aggregate using the sum of the data, equivalent to the SUM function. |

unknown = "Unknown" | Aggregation function is unknown or unsupported. |

variance = "Variance" | Aggregate using the variance of the data, equivalent to the VAR function. |

varianceP = "VarianceP" | Aggregate using the variance of the data, equivalent to the VARP function. |

## Feedback

Send feedback about:

Loading feedback...