Look at GetPivotData formula. To that end type an = and then select the total
count. You should get a getpivotdata formula. If you don't then you need to
make a change that is described here...

http://www.contextures.com/xlPivot06.html
--
HTH...

Jim Thomlinson


"erick-flores" wrote:

Hello all

I am trying to get the count from a field in a pivot table outside of
the pivot table. I already have the count in the PT but because it is
lots of data I do want to show the count at the top of my worksheet. I
tried doing the =G20188 (which is the totalcount field in my pivot
table) but of course when I refresh the data (and the data has
increase or decrease) my formula will not adjust, it will give me the
same value of cell G20188.

Any ideas?

Thanks