B15 is a subtotal from several values in the pivot table.

"Bernard Liengme" wrote:

I think we need to know the criteria that makes B15 the one to use.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"juanpablo" wrote in message
...
I have the following problem.

On top of cell B20 like in B15 there is a pivot table.
My problem is that in cell B20 I have a formula that uses the value from
B15, but every time the pivot table changes, the value I need is no longer
on
B15 but in B17 or B13 depending if there is more or less data in the pivot
table.

How can I still use the value from B15 in order to keep my formula in B20
intact?

Thanks to all.