This article describes the formula syntax and usage of the CUBESETCOUNT function in Microsoft Excel.


Returns the number of items in a set.



The CUBESETCOUNT function syntax has the following argument:

  • 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.


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



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

Applies To: Excel 2016 for Mac, Excel 2007, Excel 2016, Excel Starter, Excel 2010, Excel Online, Excel 2013, Excel for Mac 2011

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language