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.