Menu
EXCEL CUBESETCOUNT FUNCTION
Excel CUBESETCOUNT Function Introduction
The number of objects in a set is returned.
Description of Excel CUBESETCOUNT Function
Syntax :
=CUBESETCOUNT(set)
Parameters :
- A text string containing a Microsoft Excel equation that evaluates to one of the sets defined by the CUBESET function. Set can either be the CUBESET function or a reference to a cell with the CUBESET function.
Step By Step Guide of CUBESETCOUNT Function
Example :
- =CUBESETCOUNT(A3) \s
- =CUBESETCOUNT(CUBESET(“Sales”,”[Product].
[Everything].
Children”,”Products”,1,”[Measures].
[Sales
Key Points
When the CUBESETCOUNT function evaluates, it shows a “#GETTING DATA…” message in the cell for a short period of time before retrieving all of the data.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
