 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Summarizing updated external data
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 > 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 [quoted text clipped - 9 lines] > 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. 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" <n...@here.com> 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 [quoted text clipped - 11 lines] > 1/2/08 -- $10.50 -- 10 --- $500 ---- 100 > 1/3/08 -- $12.35 -- 12 --- $500 ---- 250 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.