No problem, at least it is creating a bit more warmth over here <bg

Bob

"Roger Govier" wrote in message
...
Hi Bob

As you know, today is not a good day<bg. The glow is increasing!!!
In copying yourr formula, and taking out the line wraps from the email,
I inadvertently removed the space between the last "Grand" and "Total",
hence the result it was returning for me.

Having corrected for that, the formula does return the value for the
last column in the Grand Total row as you say.
My apologies.

--
Regards

Roger Govier



Bob Phillips wrote:
Hi Roger,

No, it returns the last column in the row that contains Grand Total.


"Roger Govier" wrote in message
...
Hi Bob

Doesn't that just produce the result "Grand Total"?
I'm not really sure what the OP is after, or what he wants to do with
the result, as the Grand Total row in the PT is going to provide the
various totals.
If he just wants to know which row the Grand Total appears on then
=MATCH("Grand Total",E:E,0) will provide the row number

--
Regards

Roger Govier



Bob Phillips wrote:
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)


"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