Results 1 to 9 of 9

Get Daily Average Sales for a range of dates

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2004
    Posts
    55

    Get Daily Average Sales for a range of dates

    I'm trying to analyze my data to see which days of the week are the most profitable on average....

    Simple Example
    Column A is the date (ie. 9/27/2010)
    Column B is the amount Profit/Loss (ie. $200)

    I want to use the date range (A1:A150) to calculate the average P/L for each specific weekday but can't seem to figure out how to make it work. Anyone that can provide any quidance is greatly appreciated.

    Trying for results like this
    Monday: "Average Monday Profit Loss"
    Tuesday: "Average Tuesday Profit Loss"
    Wednesday: "Average Wednesday Profit Loss"
    etc....

    An actual sample set of data is attached.
    Attached Files Attached Files
    Last edited by pjw23; 09-27-2010 at 09:22 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1