Cube - CUBESETCOUNT Function

Description

The CUBESETCOUNT function returns the number of items in a set.

CUBESETCOUNT (set)

Argument	Description	Required/ Optional
set	A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function. OR The CUBESET function. OR A reference to a cell that contains the CUBESET function.	Required

Argument

Description

Required/ Optional

set

A text string of a Microsoft Excel expression that evaluates to a set defined by the CUBESET function.

The CUBESET function.

A reference to a cell that contains the CUBESET function.

Required

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

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_cube_functions.htm