GETPIVOTDATA for a range

I'm not sure if this is the right sub-forum for this, but hopefully I've got it right.

I have a revenue report that I'm trying to redesign following a complete overhaul of our data system. I'm trying to streamline what used to be a thick stack of macros and dozens of data files into a pivot table that feeds into the report everybody's used to getting. For the monthly data, it's working pretty well.

The problem I'm running into is my "Year to Date" values. What I'm trying to do is create a GetPivotData function that will pull all the values for a given accounting string, the current fiscal year, and for all monthly periods equal to or less than the current one.

I know that I *could* do this by layering IfError statements and just creating the formula for each period, but that would rapidly get unwieldy to say the least (thirteen iterations of my monthly formula, which is already a combination of 4 different GetPivotData formulas due to fields where multiple accounting strings get added together... it would work out to something like a total of 52 different GetPivotData functions, and probably Excel reaching out of the computer to strangle me for doing that to it.)

Any suggestions? I'd *really* like to just be able to do something like:

Please Login or Register  to view this content.

, which (to trim out all the excess references you don't need to get details on) would translate into:

Please Login or Register  to view this content.

However, Excel refuses to even try to process that.

Any suggestions?

I tried that, but unfortunately now I can't get any of my SumIfs to work properly with it. I suspect I'll have to change my approach at this rate, but thanks for your advice. Any other suggestions, I'm willing to give them a shot.