Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=CUBESETCOUNT(A3)
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
CUBEKPIMEMBER
CUBEMEMBER
CUBEMEMBERPROPERTY
CUBERANKEDMEMBER
CUBESET
CUBEVALUE
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›