View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ju
 
Posts: n/a
Default Counta and rows..

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