+ Reply to Thread
Results 1 to 4 of 4

Average If Weekday

  1. 07-08-2011, 04:46 AM #1
    freud1
    freud1 is offline
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Average If Weekday

    Hi Guys,

    Column A contains sequential dates from row 1 - 365.
    Column B contains data for the corresponding day.

    I need a formula that will give me the average for all MONDAYs

    anyhelp?

    cheers!
    Last edited by freud1; 07-08-2011 at 06:06 AM.
    Reply With QuoteRegister To Reply
  2. 07-08-2011, 04:50 AM #2
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Average If Weekday

    Perhaps

    Please Login or Register  to view this content.
    entered with Ctrl Shift Enter
    Reply With QuoteRegister To Reply
  3. 07-08-2011, 05:06 AM #3
    freud1
    freud1 is offline
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Re: Average If Weekday

    GREAT!

    worked when i edited it to

    =average(if(weekday(a1:a365,2)=1,B1:B365,false))

    many thanks
    Reply With QuoteRegister To Reply
  4. 07-08-2011, 05:09 AM #4
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Average If Weekday

    You're right, sorry about the mistake
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1