Home › Functions › Cube › CUBESETCOUNT
fx
CUBESETCOUNT
Cube  ·  Since: Excel 2003  ·  9 languages

Returns the number of items in a set.

🌐 Translations

English CUBESETCOUNT
Deutsch CUBEMENGENANZAHL
Français NBJEUCUBE
Español RECUENTOCONJUNTOCUBO
Italiano CONTA.SET.CUBO
Português CONTAGEMCONJUNTOCUBO
Nederlands KUBUSSETAANTAL
Polski LICZNIK.MODUŁÓW.ZESTAWU
Русский КУБЧИСЛОЭЛМНОЖ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

CUBESETCOUNT(set)

Arguments

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.

▶ Examples

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

Related functions

Copied to clipboard