Summarizing updated external data

[Jordan]

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

 

[Pete_UK]

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

 

[Jordan]

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.




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