I have a range of data in a sheet that I want to subtotal using sum and
average at the same time. Is this possible?
Column A: Account Name
Column B: Invoice Amt
Column C: Age

At each change of Account Name I want to subtotal
Column b by sum
Column c by average
Is this possible?

Hi
have a look at the SUBTOTAL function in Excel's help

--
Regards
Frank Kabel
Frankfurt, Germany

"Patricia" schrieb im Newsbeitrag
...
I have a range of data in a sheet that I want to subtotal using sum
and
average at the same time. Is this possible?
Column A: Account Name
Column B: Invoice Amt
Column C: Age

At each change of Account Name I want to subtotal
Column b by sum
Column c by average
Is this possible?

You can subtotal both on the same data using Data Subtotals, but you have
to do each one separately and uncheck the box labeled "Replace current
subtotals"

Carlos

"Patricia" wrote in message
...
I have a range of data in a sheet that I want to subtotal using sum and
average at the same time. Is this possible?
Column A: Account Name
Column B: Invoice Amt
Column C: Age

At each change of Account Name I want to subtotal
Column b by sum
Column c by average
Is this possible?