Sorry,
I have column "A" with a cell named District, column "B" with a cell named
Region, etc. Have auto-filters applied and want to have the subtotals show
values of the filtered columns and show the "filtered" numbers with the cell
reference. (i.e. Region 234)
A B C D E F

District Region State Name Area Numbers


Thanks again,
bg
"Marcelo" wrote in message
...
Hi Bg, maybe I did not understand exactly you are looking for.

you told about the Column name what it's mean? A, B or C?

regards

"Bg" escreveu:

Marcelo,
Thanks for the response, but I don't understand what your suggesting.
Where
should I add ( INSERT | NAME ) to my existing formula?
=subtotal(2,C:C)

Thanks
Bg

"Marcelo" wrote in message
...
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