Suming values in Pivot Table

[jak82]

Hi,

I have a pivot table like below

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201509[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201517[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201527[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201540[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201544[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201546[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201548[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]201550[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 176"]
<tbody>[TR]
[TD="class: xl66, width: 176"]Agriculture / Pets[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 176"]
<tbody>[TR]
[TD="class: xl66, width: 176"] 2017[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 176"]
<tbody>[TR]
[TD="class: xl66, width: 176"] January[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]10.23[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]10.23[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD][TABLE="width: 176"]
<tbody>[TR]
[TD="class: xl66, width: 176"] February[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 49"]
<tbody>[TR]
[TD="width: 49, align: right"]10.23[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 176"]
<tbody>[TR]
[TD="class: xl66, width: 176"] March[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10.23[/TD]
[TD]10.23[/TD]
[TD]10.23[/TD]
[TD]10.23[/TD]
[TD]10.23[/TD]
[/TR]
</tbody>[/TABLE]


I am wanting to to sum all the values from 201509 to 201550 for March.

How would I go about doing that with Sumproducts?

A single get pivot looks like

=GETPIVOTDATA(GETPIVOTDATA("[Measures].[Sum of InsertNetCost]",$B$5,"[CalendarNew].[Fin Year]","[CalendarNew].[Fin Year].&[2017]","[category].[category]","[category].[category].&[Agriculture / Pets]","[adTrans].[FinWeek Number]","[adTrans].[FinWeek Number].&[2.01603E5]")

Thanks for help