+ Reply to Thread
Results 1 to 3 of 3

formula array with 2 criteria

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    formula array with 2 criteria

    hi guys

    in cell ac30 im looking to return the average of column L IF column c is matched by whats in cell B2 and if column b falls between dates of 07/08/14 and 20/07/16

    would appreciate any help

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: formula array with 2 criteria

    Sounds like you just need to use AVERAGEIF with three criteria; C2:Cx, $B$2, date >= start date, and date <= end date.

    Suggest you post a sample workbook so we can see the data layout and have something to test with.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    08-07-2015
    Location
    AB, Canada
    MS-Off Ver
    Excel 2013 x64
    Posts
    132

    Re: formula array with 2 criteria

    You may have to adjust the ranges that this formula applies to based on your actual dataset. I assumed your data you're matching in columns B, C, and L starts in row 30 and goes to row 66. Once you adjust the ranges to fit what your data, this solution should work.

    Please Login or Register  to view this content.
    Let me know if that works for you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Array Formula for multiple criteria
    By nickmessick1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2013, 11:23 AM
  2. Array formula + Array formula with criteria that lookups a Table
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 11:41 AM
  3. Sumif formula on an array of criteria?
    By Dial1 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-07-2013, 05:29 PM
  4. Array Formula: Weighted Avg with Min/Max criteria
    By ExcelNewbeee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2013, 01:16 PM
  5. [SOLVED] Excel 2007 : Multiple criteria without using an array formula
    By picasso194 in forum Excel General
    Replies: 7
    Last Post: 05-20-2012, 12:33 PM
  6. Array Formula with multiple criteria
    By amotto11 in forum Excel General
    Replies: 2
    Last Post: 05-14-2012, 03:22 PM
  7. Array Formula - two worksheets, two criteria
    By tdonov02 in forum Excel General
    Replies: 1
    Last Post: 12-19-2011, 07:25 PM
  8. Array formula with an additional criteria
    By harleypop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2009, 01:28 AM

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