Subtotal with two functions
 

Hello I have a very large sheet and I would like to add subtotals at each
Order type. Column B and C will have Sum and Column D and E will have
Average. It's possible to do it at once? Subtotals gives only one option
Example:
OrderT Tot Dlrs Units #Days1 #Days2
SO $25.00 1 32 1
SO $67.50 1 31 1
ST $20.00 2 27 1
ST $25.50 1 29 3
SR $240.00 4 29 1
SR $180.00 3 29 1
SE $25.00 1 22 2
SE $75.00 1 23 1
SE $27.50 1 20 1
Sum Sum Average Average

Subtotal with two functions
 

You can do a single Data|Subtotals and use Sum for all 4 columns.

Then after you're done, you can use
Select columns D:E
edit|replace
what: =subtotal(9,
with: =subtotal(1,
replace all


Compare Values wrote:

Hello I have a very large sheet and I would like to add subtotals at each
Order type. Column B and C will have Sum and Column D and E will have
Average. It's possible to do it at once? Subtotals gives only one option
Example:
OrderT Tot Dlrs Units #Days1 #Days2
SO $25.00 1 32 1
SO $67.50 1 31 1
ST $20.00 2 27 1
ST $25.50 1 29 3
SR $240.00 4 29 1
SR $180.00 3 29 1
SE $25.00 1 22 2
SE $75.00 1 23 1
SE $27.50 1 20 1
Sum Sum Average Average

--

Dave Peterson

Subtotal with two functions
 

Thank you very much.

"Dave Peterson" wrote:

You can do a single Data|Subtotals and use Sum for all 4 columns.

Then after you're done, you can use
Select columns D:E
edit|replace
what: =subtotal(9,
with: =subtotal(1,
replace all


Compare Values wrote:

Hello I have a very large sheet and I would like to add subtotals at each
Order type. Column B and C will have Sum and Column D and E will have
Average. It's possible to do it at once? Subtotals gives only one option
Example:
OrderT Tot Dlrs Units #Days1 #Days2
SO $25.00 1 32 1
SO $67.50 1 31 1
ST $20.00 2 27 1
ST $25.50 1 29 3
SR $240.00 4 29 1
SR $180.00 3 29 1
SE $25.00 1 22 2
SE $75.00 1 23 1
SE $27.50 1 20 1
Sum Sum Average Average

--

Dave Peterson