+ Reply to Thread
Results 1 to 5 of 5

need 2 range to work with 1 criteria in the formula

  1. #1
    Registered User
    Join Date
    08-25-2016
    Location
    uk
    MS-Off Ver
    2010
    Posts
    40

    need 2 range to work with 1 criteria in the formula

    Hello great people,

    I am using this formula:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I would like to add another range into this formula. I tried the below, but it doesn't work.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    any help would be greatly appreciated

    Thank you
    ExxcelTriumph

  2. #2
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: need 2 range to work with 1 criteria in the formula

    It looks like you can define that in one array?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-25-2016
    Location
    uk
    MS-Off Ver
    2010
    Posts
    40

    Re: need 2 range to work with 1 criteria in the formula

    thank you for the quick reply,

    i would like to avoid rows 5 & 6, that the reason i want 2 arrays.

    any help please?

    exceltriumph

  4. #4
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: need 2 range to work with 1 criteria in the formula

    Your arrays need to be the same size otherwise it can't sum the arguments. Are you trying to get a count of the total number of the dates? My understanding of sumproduct is that it will multiply the corresponding cells in each array so won't give you the count. for that you would just need to do the two arays as separate formuals:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-25-2016
    Location
    uk
    MS-Off Ver
    2010
    Posts
    40

    Re: need 2 range to work with 1 criteria in the formula

    Yes, that's what i was trying to achieve, thank you for the explanation. it worked like a charm.

+ 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. VBA to search in data range based on criteria from a different work sheet
    By tompee29 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2015, 12:37 PM
  2. Replies: 9
    Last Post: 11-19-2014, 04:15 PM
  3. Replies: 6
    Last Post: 10-22-2014, 09:07 AM
  4. Replies: 8
    Last Post: 03-22-2013, 03:40 PM
  5. Why would a COUNTIF formula work for one criteria and not another, how do I fix this?
    By necht_angel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2012, 06:44 AM
  6. Replies: 1
    Last Post: 05-16-2011, 05:00 PM
  7. Auto Filter Delete Rows by Criteria Doesn't Work Range To Complicated
    By robertjtucker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2005, 01:05 PM

Tags for this Thread

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