+ Reply to Thread
Results 1 to 2 of 2

Average if between two dates

  1. #1
    Registered User
    Join Date
    05-07-2009
    Location
    leeds, england
    MS-Off Ver
    Excel 2007
    Posts
    29

    Average if between two dates

    Hello,
    I'm sure this is a very easy problem to fix but why isnt my averageif formula working?!

    =AVERAGEIF(Sheet2!A:A,"<=A3&>A4",Sheet2!D:D)

    Thanks,

    Rich
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Average if between two dates

    You would use AVERAGEIFS and you would have two separate tests namely: "<="&A3 and ">"&A4

    =AVERAGEIFS(Sheet2!D:D,Sheet2!A:A,"<="&A3,Sheet2!A:A,">"&A4)

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1