rhombus4
Wellknown Member
 Joined
 May 26, 2010
 Messages
 533
 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),"")