Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GETPIVOTDATA Sum of cells
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GETPIVOTDATA Sum of cells
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? "Sarah (OGI)" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA | Excel Discussion (Misc queries) | |||
getpivotdata | Excel Worksheet Functions | |||
GETPIVOTDATA between XL 2K & 03 | Excel Discussion (Misc queries) | |||
GETPIVOTDATA | Excel Discussion (Misc queries) | |||
GetPivotData | Excel Worksheet Functions |