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

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

etc. is short for "Et cetera" which means "And so on" or "And other
things". I was just saying that there are a lot more fields that I did not
want to list out.




"Pete_UK" wrote in message
...
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