What does the etc mean in " ... customer order lines that have the
customer id, part, qty, price, etc ..." ? Please give details of the
columns you use for the data.

Also, in your summary table you have a column for average $ - how is
this to be worked out? Total$ divided by # of Orders or by Total
Units? Neither of these seem to be the case in your examples.

Hope this helps.

Pete

On May 8, 4:42*pm, "Jordan" wrote:
I have a basic sheet that refreshes external data based on what someone
fills in for starting and ending dates in a couple of cells. *The data is
just a bunch of customer order lines that have the customer id, part, qty,
price, etc.

I want a variety of summaries of some of the data on the side of the sheeet
or where ever, but I don't know the functions to use that will do somethnig
like the following automatically.:

Date *--- * Avg $ --- # of Ord --- Total$ *--- Total Units
1/1/08 -- $15.00 *-- *20 *--- * * $500 * *---- * *300
1/2/08 -- $10.50 *-- *10 *--- * * $500 * *---- * *100
1/3/08 -- $12.35 *-- *12 *--- * * $500 * *---- * *250