ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I subtotal then average the subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/223946-how-can-i-subtotal-then-average-subtotals.html)

amaries

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.


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com