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
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