ConsolidationFunction Property

Applies To

Worksheet Object.

Description

Returns the function code used for the current consolidation (one of xlAverage, xlCount, xlCountNums, xlMax, xlMin, xlProduct, xlStDev, xlStDevP, xlSum, xlVar, or xlVarP). Read-only.

See Also

Consolidate Method, ConsolidationOptions Property, ConsolidationSources Property.

Example

This example displays a message box if the current consolidation is using the SUM function.

If Worksheets("Sheet1").ConsolidationFunction = xlSum Then
    MsgBox "Sheet1 uses the SUM function for consolidation."
End If