rhombus4
Well-known Member
- Joined
- May 26, 2010
- Messages
- 586
- Office Version
- 365
- 2016
- Platform
- Windows
Trying to Add up a Range using GETPIVOTDATA as there are too many combination of Days i.e. -5, -8, 1, 3, 8, 12, 15, 21 etc etc
Currently have
which will show me the count of 1 Day
What I need is to be able to add a range or maybe non contiguous values i.e.
Want to get the Values added for 1 2 and 3 or Sum(1:3)
what formula below does is overspill and enters Count of 1 in Col W, Count of 2 in Col X and Count of 3 in Col Y
or
Want to get the Values added for 2 4 and 6
Currently have
Excel Formula:
=IFERROR(GETPIVOTDATA("Category",$S$145,"Category","Equipment","Days",1),"")
What I need is to be able to add a range or maybe non contiguous values i.e.
Want to get the Values added for 1 2 and 3 or Sum(1:3)
what formula below does is overspill and enters Count of 1 in Col W, Count of 2 in Col X and Count of 3 in Col Y
Excel Formula:
=IFERROR(GETPIVOTDATA("Category",$S$145,"Category","Equipment","Days",{1,2,3),"")
or
Want to get the Values added for 2 4 and 6
Excel Formula:
=IFERROR(GETPIVOTDATA("Category",$S$145,"Category","Equipment","Days",{2,4,6),"")