+ Reply to Thread
Results 1 to 2 of 2

Counting number of rows having a particular string in two different columns

  1. #1
    Registered User
    Join Date
    12-06-2018
    Location
    Norway
    MS-Off Ver
    1811
    Posts
    31

    Counting number of rows having a particular string in two different columns

    Hello,

    I have attached a sample of the data I'm working with. Basically, I would like to count the number of rows in my table that:

    1) Contain the string "sprit" in column B,

    AND

    2) Do not hav "no-DNA profile" on column A.

    I've been using the following formula to count the number of rows having "no-DNA profile" on column A:

    =COUNTIF(A1:A1183,"no DNA-profile")

    And when substracting that and the total number of empty cells to the total number of cells in the table, I've been able to count the number of rows responding to criteria 2). However, I'm unsure about how to add a second level of complexity to my formula by counting the number of rows also fulfilling criteria 1).

    If somebody could at least set me on the right track, that would be truly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Counting number of rows having a particular string in two different columns

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by KOKOSEK; 11-22-2019 at 08:19 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-13-2017, 12:24 AM
  2. [SOLVED] Counting most common string across two columns
    By omidpyc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2015, 09:29 AM
  3. Counting number of columns that contain a certain text string
    By dvrs in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2013, 10:11 AM
  4. [SOLVED] Counting the number of times a particular string comes up?
    By Rymbeld in forum Excel General
    Replies: 4
    Last Post: 09-22-2012, 02:05 PM
  5. Counting Instances of A String in Non-Contiguous Columns
    By robertmdvs in forum Excel General
    Replies: 6
    Last Post: 10-25-2011, 02:47 PM
  6. Conditional counting of a string in 2 columns
    By Exboy in forum Excel General
    Replies: 11
    Last Post: 06-22-2011, 12:56 PM
  7. Counting Rows Then Counting Values in Columns
    By Michael via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2005, 12: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