Hi Bg,

try to include a name ( INSERT | NAME ) for the column and use it on the
formula, eg. select all data from column "Region" and named it as "Region"

hth
regards from Brazil
Marcelo

"Bg" escreveu:

Have a worksheet with several columns. Region, District, State, Name,
etc,etc, etc. I have displayed the sub-totals in cell (=subtotal(2,A;A) but
want to include the column name (i.e Region 1234, State 123). Is there a
formula that can include the column name. Or even in a adjoining cell..
Thanks very much.

bg