View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Morgan Morgan is offline
external usenet poster
 
Posts: 39
Default average hourly output for date, result shown by day

thanks Max


"Max" wrote:

.. plug into the table below, for each day and would return the results

mm, but that's exactly what was suggested?
How about a little working sample to illustrate it:
http://cjoint.com/?lfqpzRHQm2
Average n Sum by day.xls
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Morgan" wrote:
sorry Max, i couldn't get it to work, the first formula seems to leave out
column M 'output' i just wanted a formula that i could plug into the table
below, for each day and would return the results, thanks for trying though

Average Hourly Output Total Output
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday


--
thanks