Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotal functions | Excel Worksheet Functions | |||
Combining subtotal and sumif functions | Excel Worksheet Functions | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Combining SUMIF and SUBTOTAL functions | Excel Worksheet Functions | |||
Can you combined the SUMIF and SUBTOTAL functions in a formula? | Excel Worksheet Functions |