Is there a way to use the subtotal function on the tools menu to have a sum
and avg in the same subtotal line? For instance you may want to total one
column and avg another column all on the same row.

Create one subtotal using that method, then copy that formula acroos, but
change the 9 to a 1

--
HTH

RP
"JJ" wrote in message
...
Is there a way to use the subtotal function on the tools menu to have a
sum
and avg in the same subtotal line? For instance you may want to total one
column and avg another column all on the same row.

Sorry, I met on the data menu. I have several different groups that need to
be subtotaled and I need to be able to expand and contract.

"JJ" wrote:

Is there a way to use the subtotal function on the tools menu to have a sum
and avg in the same subtotal line? For instance you may want to total one
column and avg another column all on the same row.

Bob,

So I created a subtotal using "sum" on columns 1 and 3. On column 2 I want
it to "avg". There are like a hundred groups that are being subtotaled. Do I
have to go through each group's subtotal row manually and drag the formula
across and change it to "avg"?

"Bob Phillips" wrote:

Create one subtotal using that method, then copy that formula acroos, but
change the 9 to a 1

--
HTH

RP
"JJ" wrote in message
...
Is there a way to use the subtotal function on the tools menu to have a
sum
and avg in the same subtotal line? For instance you may want to total one
column and avg another column all on the same row.

Use Sum for both columns.

Then you'll end up with subtotal formulas like:

=subtotal(9,a2:axx)
and
=subtotal(9,c2:cxx)

Select the column that should have averages and
edit|replace
what: =subtotal(9,
with: =subtotal(1,
replace all



JJ wrote:

Is there a way to use the subtotal function on the tools menu to have a sum
and avg in the same subtotal line? For instance you may want to total one
column and avg another column all on the same row.

--

Dave Peterson