LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
chrisandfarah
 
Posts: n/a
Default seperating days of week in a database

My database has columns headed with food sales, bar sales, net sales, etc..
The rows are numbered by day of week, with the day of the week in the next
column. Is it possible to determine the average for each type of sale for
each day of the week. For example, what are my average food sales on fridays
and wednesdays?

I would like to do this without manually changing my formulas every month.

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Dates in Days of the Week Eagle784 Excel Discussion (Misc queries) 3 August 19th 05 05:31 PM
Do not show $ per week when days remain < 7 Walterius Excel Discussion (Misc queries) 2 June 11th 05 02:44 AM
user defined function Brian Rogge Excel Worksheet Functions 5 May 23rd 05 06:21 PM
selecting days of week using a formula in spreadsheets Terry Excel Worksheet Functions 6 April 23rd 05 01:19 PM
Days of the week. Johan Bornman Excel Worksheet Functions 1 November 10th 04 05:25 PM


All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"