Results 1 to 9 of 9

Avoid Double Counting - Ignore Text in Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    20

    Avoid Double Counting - Ignore Text in Criteria

    Hi All,

    I'm struggling again with the excel logic to perform something that feels simple, it's frustrating!

    Ok here some sample data:

    avoid double counting.jpg

    I'm trying to create a formula that checks an ID and returns TRUE if a type other than "apple" or "banana" is there. The problem I'm having is double counting so if I write something like:

    =IF(SUM(--(COUNTIFS($A$2:$A$15,C2,$B$2:$B$15,{"<>apple","<>banana"})>0))=2,TRUE," ")

    it doesn't work because when counting excluding "apple" it counts "banana" and vice versa.

    I want to do something with OR or AND, but that doesn't work or I can figure it out.

    Help greatly appreciated!

    Thank you
    Last edited by SamFitz; 09-29-2016 at 09:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Text trimmer double criteria
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-15-2015, 03:10 PM
  2. [SOLVED] Avoid double counting of same value
    By Karen57 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-02-2015, 09:23 AM
  3. How to avoid double-counting inventory after it has been accounted for?
    By excelrookie2014 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-05-2014, 07:37 PM
  4. VBA combo boxes (ignore blanks + avoid duplicates)
    By pbobadilla in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2012, 05:44 PM
  5. [SOLVED] how to avoid null/double click
    By var in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  6. [SOLVED] Need help on counting text within certain criteria
    By christinac in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-27-2006, 08:15 AM
  7. [SOLVED] Counting text criteria
    By Belinda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2005, 06: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