GETPIVOTDATA Sum of cells

[Sarah (OGI)]

I have a pivot table with dates, by month, along the top (in a "mmm-yy"
format) and then the name of 8 companies listed down the left-hand pane.

Is there any way, using the GETPIVOTDATA function, to sum the values
associated with the financial YTD range.

For example, I am doing a report for August 2008 for Company A. I therefore
need to sum the values for June 2008, July 2008 and August 2008 (BS6:BU6). I
cannot group the data as it will change every month.

Any ideas?

Many thanks

 

[Sean Timmons]

Would probably be easier to just use a SUMPRODUCT off the source table.

=SUMPRODUCT(--(companycolumn2:companycolumn5000=company name
cell),--(monthcolumn2:monthcolumn5000=monthcell),data))
=SUMPRODUCT(--(companycolumn2:companycolumn5000=company name
cell),--(monthcolumn2:monthcolumn5000=month(monthcell)-1),data))
=SUMPRODUCT(--(companycolumn2:companycolumn5000=company name
cell),--(monthcolumn2:monthcolumn5000=month(monthcell)-2),data))

Would that work for you?