| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I subtotal then average the subtotals
Hello all. I don't get to use excel alot so I am hoping someone can help me
out. Probably basic so please forgive me. I have a worksheet of orders for a specific customer# (clmn A). It lists the order #(clmn B) part#(clmn C) and part $$ (clmn D) and the order date (clmn E). I need to subtotal the orders (order $) then get an average order value. The orders are a variety of line items per order. I can subtotal but how do I get an average of all the subtotals? Thanks for any tips/hints. running excel 2007, on XP SP3. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting a subtotal list by the subtotals | Excel Discussion (Misc queries) | |||
| Subtotal, then sort groups by their subtotals | Excel Worksheet Functions | |||
| Subtotals not working correctly when 2nd subtotal added | Excel Worksheet Functions | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| Subtotal results in new column and then sorting subtotals | Excel Worksheet Functions | |||
Threaded Mode
