Results 1 to 4 of 4

COUNTIF formula excluding large list of values from count

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    Spain
    MS-Off Ver
    365
    Posts
    19

    COUNTIF formula excluding large list of values from count

    Dear, I am looking for a formula where I can use countif excluding a large list of values.

    Example in attach: Tab results shows in result 0 if in the value column one of the characters appears from my 'lookup exclusions' tab. If the characters doesn't appear in my lookup list it should return 1.

    In reality the lookup list and data set is a lot bigger - this is just an example.

    Thank you!
    Tupelo
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-03-2014, 11:06 AM
  2. Replies: 1
    Last Post: 01-10-2014, 01:55 PM
  3. Replies: 4
    Last Post: 11-08-2013, 05:01 AM
  4. [SOLVED] Sum Large values along with Count Condition - Array Formula
    By acsishere in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2013, 05:45 PM
  5. [SOLVED] need formula to count number of cells that contain any of a LARGE list of zip codes
    By Security in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-14-2012, 10:37 AM
  6. excluding values using countif
    By hooha2012 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2012, 06:04 PM
  7. Replies: 4
    Last Post: 12-24-2008, 02:53 AM
  8. [SOLVED] How do I use countif to count values excluding blank cells
    By Glenda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2006, 12:30 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