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

  • This function was introduced in Excel 2007 and so is not available in earlier versions.

Syntax

=CUBESETCOUNT(set)

Arguments

Argument Description
set A text string of an Excel expression that evaluates to a set defined by the CUBESET function. Set can also be:

  the CUBESET function
  a reference to a cell that contains the CUBESET function

Examples

  A B
1 Formula  
2 =CUBESETCOUNT(A3)  
3 =CUBESETCOUNT(CUBESET(“Sales”,”[Product].[All Products].Children”,”Products”,1,”[Measures].[Sales Amount]”))