Subtotal with two functions

C

Compare Values

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
 
D

Dave Peterson

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
 
C

Compare Values

Thank you very much.

Dave Peterson said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top