Skip to content

cubevalue

Excel Cube functions explained: Cubevalue, Cubeset, Cubemember

One of my favorite Excel functions to do business modeling are Cube functions. They act as a more efficient replacement for SUMIFS, GETPIVOTDATA functions that serve to sum aggregated results with various filters applied. Cube functions (CUBEVALUE, CUBEMEMBER, CUBESET) will only work if you have a PowerPivot model or live cube connection in your Excel file. How to use Cube functions In my experience, when using Cube functions, I prefer… Read More »Excel Cube functions explained: Cubevalue, Cubeset, Cubemember

Excel CUBEVALUE vs SUMIFS & GETPIVOTDATA

Once CUBEVALUE formula came out about 10 years ago along with PowerPivot, I was delighted because it had filled the gap that was missing in SUMIFS and GETPIVOTDATA formulas for certain usage scenario.