Getpivotdata with a range criteria

cstlaurent

Board Regular
Joined
Jan 14, 2005
Messages
182
I am still looking first of all if it's possible, with the getpivotdata to retreive a sum from the pivot data of an array of cell. Ex:

I want the sum of all the center that is included in an array.

sum of $center .. date
center ...............01-01-05 02-01-05 03-01-05 04-01-05 05-01-05
2001..................100 150 200 300 100
2002..................200 400 150 100 400
2003..................50 75 200 150 170
2004..................80 10 200 100 85
2005..................150 100 80 90 200
2006..................100 150 80 200 400
2007..................90 90 90 90 90


array of selection
2001
2002
2005
2006

I allready use the function sumproduct instead of the crosstable, but it was taking way to much time, because I have a few thousand of record to go look into each time.

Any help will be appréciate.

thanks :oops:
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,148,220
Messages
5,745,456
Members
423,952
Latest member
EduardoM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top