Results 1 to 19 of 19

Count Number of Rows Based on Criteria

Threaded View

  1. 05-24-2023, 01:28 PM #11
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Count Number of Rows Based on Criteria

    Please try

    =SUM(--BYROW(FILTER(Table1,ISNUMBER(XMATCH(Table1[#Headers],"column"&TEXTSPLIT("5, 6, 7, 8, 19, 21, 22, 31",", ")))),LAMBDA(a,OR(ISNUMBER(SEARCH("Unknown",a)),a=0))))
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    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. Count number of rows until certain value and run another macro based on the count value
    By Chanty in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2021, 01:04 PM
  2. [SOLVED] Count number of lines based on text and number criteria, without duplicates
    By HVCompleto in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2017, 07:17 AM
  3. [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
  4. [SOLVED] Count number of occurrences based on criteria in multiple columns and rows
    By gerryger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2015, 08:13 PM
  5. [SOLVED] Count number of rows meeting either criteria
    By abousetta in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-14-2014, 05:35 AM
  6. Trying to count number of rows where criteria are met in columns
    By kfloyd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2013, 01:45 PM
  7. Count number of rows with multiple criteria
    By spinx in forum Excel General
    Replies: 5
    Last Post: 09-17-2010, 09:17 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1