Subtotals

J

JJ

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.
 
B

Bob Phillips

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

JJ

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.
 
J

JJ

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"?
 
D

Dave Peterson

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
 
Top