M,
Sorry, I'm not explaining this right. I understand how to add "text" to the
formula. Question is, how to add the name on the column that is filtered and
add it to the subtotal count. Any one of the columns might be filtered,
therefore the text might change from "Regions" or "District" or "Name", etc.

Bg

"Marcelo" wrote in message
...
Bg, the contens "Regions" or are named Regions? I'm asking because you
could
gave a name for a cell or a range (insert | name) as I told you before...
if
you just want the "header" of the column before the result of the subtotal
to
identify for where the results came use

="Region"&" "&subtotal(2,b:b)

hth
regards from Brazil.



"Bg" escreveu:

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