# Enum DataConsolidateFunction

Specifies values for the data consolidation function.

**Namespace**: DRIT.Spreadsheet

**Assembly**: DRIT.Spreadsheet.dll

##### Syntax

`public enum DataConsolidateFunction : int`

### Fields

Name | Description |
---|---|

Average | The average of the values. |

Count | The count of data values. |

CountNumbers | The count of data values that are numbers. |

Maximum | The largest value. |

Minimum | The smallest value. |

Product | The product of the values. |

StandardDeviation | An estimate of the standard deviation of a population, where the data to be summarized is a subset of the entire population |

StandardDeviationPopulation | The standard deviation of a population, where the population is all of the data to be summarized. |

Sum | The sum of the values. |

Variance | An estimate of the variance of a population, where the data to be summarized is a subset of the entire population. |

VariancePopulation | The variance of a population, where the population is all of the data to be summarized. |