Results 1 to 10 of 10

Count the number of cases that match the criteria

Threaded View

  1. 11-23-2016, 08:09 AM #1
    billj
    billj is offline
    Forum Contributor
    Join Date
    01-15-2013
    Location
    London
    MS-Off Ver
    Excel 2003, 2007, 2010, 2019, Microsoft 365.
    Posts
    440

    Count the number of cases that match the criteria

    Hello everyone,

    The formula works perfectly: =COUNT(MATCH(D1:D6,A1:A26,0)), with array applied Ctrl+Shift+Enter.

    But the formula =COUNT(INDEX(B1:B26,MATCH(D1:D6,A1:A26,0))) does not work. Is it because the INDEX function does not support array?

    I got the example here. Thanks for helping me.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count number of rows that match criteria and apply values relative to another criteria
    By Puni in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-01-2016, 03:28 PM
  2. Count cases which happen in a certain order or date with an additional criteria
    By benni55 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 10-28-2016, 12:22 PM
  3. Formula to count the number of cases that are open in a month
    By eekbubble in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2015, 10:09 AM
  4. [SOLVED] How do you count the number of dates that match a criteria
    By john dalton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2014, 09:23 AM
  5. Lookup value in sheet, and count number of cells in that row that match multiple criteria
    By gtza in forum Excel General
    Replies: 1
    Last Post: 11-20-2014, 06:21 AM
  6. [SOLVED] Count the number of instances where multiple criteria match
    By kurt.l in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-10-2012, 12:12 PM
  7. Compare two cells in a row with Criteria. Count Rows that match Criteria
    By Phenatic in forum Excel General
    Replies: 5
    Last Post: 09-22-2009, 06:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1