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.