# CUBESETCOUNT function

This article describes the formula syntax and usage of the **CUBESETCOUNT** function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

## Description

Returns the number of items in a set.

## Syntax

CUBESETCOUNT(set)

The CUBESETCOUNT function syntax has the following argument (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

**Set**Required. A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function. Set can also be the CUBESET function, or a reference to a cell that contains the CUBESET function.

## Remark

When the CUBESETCOUNT function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.

## Examples

`=CUBESETCOUNT(A3)`

`=CUBESETCOUNT(CUBESET("Sales","[Product].[All Products].Children","Products",1,"[Measures].[Sales Amount]"))`