software

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
quot;JJquot; gt; wrote in message
...
gt; Is there a way to use the subtotal function on the tools menu to have a
sum
gt; and avg in the same subtotal line? For instance you may want to total one
gt; 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.

quot;JJquot; wrote:

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

Bob,

So I created a subtotal using quot;sumquot; on columns 1 and 3. On column 2 I want
it to quot;avgquot;. 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 quot;avgquot;?

quot;Bob Phillipsquot; wrote:

gt; Create one subtotal using that method, then copy that formula acroos, but
gt; change the 9 to a 1
gt;
gt; --
gt; HTH
gt;
gt; RP
gt; quot;JJquot; gt; wrote in message
gt; ...
gt; gt; Is there a way to use the subtotal function on the tools menu to have a
gt; sum
gt; gt; and avg in the same subtotal line? For instance you may want to total one
gt; gt; column and avg another column all on the same row.
gt;
gt;
gt;

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:
gt;
gt; Is there a way to use the subtotal function on the tools menu to have a sum
gt; and avg in the same subtotal line? For instance you may want to total one
gt; column and avg another column all on the same row.

--

Dave Peterson