getpivotdata multiple items

  • Thread starter Thread starter Raeven
  • Start date Start date
R

Raeven

Is there any way to have getpivotdata retrieve more than one set o
data, other than doing it like below?

=GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg E
&I$163)+GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg M " &I$163)

For example, would it be possible to us a range of cells as a referenc
(&I$163:I$180)?

Thanks,
Stephani
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA with Date 1
GETPIVOTDATA #REF! error XL2003/2010 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Use cell_ref in place of an item in get pivot data function 2
getpivotdata having multiple items 1
GETPIVOTDATA in Excel 2007 2
Basic Pivot Table Question 1

Back
Top