Hi Ju,

Perhaps?

=OFFSET($A$1,MATCH("Grand Total",A:A,0)-1,
COUNTA(INDIRECT(MATCH("Grand Total",A:A,0)&":"&MATCH("Grand
Total",A:A,0)))-1)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ju" wrote in message
...
Hi all,

I need help on the last part of the formula:


=OFFSET($A$1,(MATCH("Grand Total",A:A,0)-1),COUNTA("where the cell in
column a contains "Grand total"))

This is for referencing the grand total in a pivot table..

I can't use a static top row, as it may contain blank cells, as fields
are added or removed.


Thank you.

Ju