Thread: Subtotals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Subtotals

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.