OK, you got me back on track! This is what I have done, but I still have one
problem.

I copied and pasted the pivot table.
I then hid details to view only subtotals
I named the subtotal companies and also the subtotal values in order to
easily refer to them in a formula
On the sheet where I need to add the totals, I used a Sumif that looks up
the company name and sums values if it appears in the companies on the pivot
table.

So far, so good. but...

For reasons beyond my control, on the sheet where I am placing the Sumif,
the company name may differ slighly from that in the pivot table. For
example, ABC may be ABC Company Inc. on the pivot table.

I think I need to use a text function within the Sumif to look up the
company in the pivot table if it CONTAINS ABC. The problem is that I have
many companies, so I want to refer to the cell that contains the company
name, not actually type "ABC". This is where I"m having problems.

Any help would be greatly appreciated and would allow me to finish this up!

Thanks!
--
Thanks!

Dee


"Debra Dalgleish" wrote:

I meant a regular copy of the pivot table, and when you update one, the
other will update automatically. You don't have to name the subtotals.
In the GetPivotData, just refer to the field name, and the data field,
and you'll get the subtotal for that item.

For example, with a field named Region, and a region name in cell D5:

=GETPIVOTDATA("Units",$B$3,"Region",D5)

would return the total units for the region.

dee wrote:
Hi Debra,

Thanks for your replay.

Yes, I had thought of that. I guess the drawback is that it isn't dynamic,
from what I can tell. I would have to paste values only, correct?

I assume that I cannot name subtotals (only) in a pivot table? I've looked
all over (including your excellent site), but can't come up with a definitive
answer.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html