Results 1 to 9 of 9

Countif in arrays with two conditions

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Countif in arrays with two conditions

    Hello everyone

    In this link I have put the same issue
    http://www.eileenslounge.com/viewtopic.php?f=30&t=25267


    But I don't need to rely on cells (colored cells are not required)

    First have a look at this code that count the range("B8:AP8") on a criteria 4,3,2,1,0 ..Run the demo code to see the results in range("AR7:AV8")
    I need to extend the criteria ..
    To count if :
    ---------------
    range("B8:AP8") on a criteria 4,3,2,1,0
    range("B7:AP7") has one of the values in range("B1:F1")

    The expected results would be like that snapshot

    Untitled.png

    for example : the number 3 happened 13 times in range("B8:AP8")
    And in range("X7:L7") the numbers 16 & 18 & 26 & 28 occurs in this range
    So the result for 3 is 4
    Hope it is clear
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Countif using vba arrays
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-10-2016, 09:20 PM
  2. COUNTIF(?) For Multiple Arrays With Multiple Conditions
    By MJ10 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-09-2014, 10:07 PM
  3. [SOLVED] CountIF VBA Arrays
    By lloydgodin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-26-2013, 08:09 PM
  4. Help with multiple conditions and arrays
    By Blackhawks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-13-2013, 03:33 PM
  5. [SOLVED] COUNTIF and arrays?
    By aikorei in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-16-2012, 11:27 AM
  6. Conditional formatting multiple conditions (arrays?)
    By Pyrex238 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2011, 02:54 PM
  7. Counting conditions in arrays
    By Steven Fleck in forum Excel General
    Replies: 1
    Last Post: 12-04-2007, 04:10 PM

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