+ Reply to Thread
Results 1 to 4 of 4

Countif problem

  1. #1
    Registered User
    Join Date
    05-03-2019
    Location
    Texas, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    6

    Countif problem

    I have 1 column with 40,000 rows. Each cell in the row has a statute e.g. §363.41(a)(1) and a paragraph of text before and or after the statute.

    I have another key/Excel sheet with 200 statutes in 1 column and 200 rows.

    Problem 1: I want to count how many times a certain statute is mentioned in the 40,000 rows.

    My attempted solution: I'm using this function: =countif(range,"*"&reference cell&"*")

    Problem 2: My attempted solution almost works. But my reference statute may be §123.45(a) and the 40,000 rows might have §123.45(a) but also §123.45(a)(b). What happens is my countif function tallies both of these statutes for my §123.45(a) reference.

    Question: How do I count only §123.45(a) and not §123.45(a)(b) when it occurs?

    Thanks

  2. #2
    Registered User
    Join Date
    05-03-2019
    Location
    Texas, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    6

    Countif problem

    Attached is an example workbook I've made
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,607

    Re: Countif problem

    Try this in column B:
    Please Login or Register  to view this content.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    05-03-2019
    Location
    Texas, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    6

    Re: Countif problem

    Thanks this really helped!

+ 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. [SOLVED] COUNTIF problem
    By CiaraJ in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-15-2016, 11:58 AM
  2. COUNTIF Problem
    By Environment in forum Excel General
    Replies: 2
    Last Post: 09-28-2011, 09:30 AM
  3. Countif problem
    By buffalobill in forum Excel General
    Replies: 2
    Last Post: 05-27-2010, 08:46 AM
  4. Countif problem
    By Rgaherty in forum Excel General
    Replies: 4
    Last Post: 03-28-2008, 11:16 AM
  5. [SOLVED] Countif Problem
    By Mark W in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2006, 03:40 PM
  6. Countif Problem
    By John Moore in forum Excel General
    Replies: 5
    Last Post: 11-27-2005, 03:15 PM
  7. [SOLVED] Countif problem
    By David Cleland in forum Excel General
    Replies: 4
    Last Post: 08-23-2005, 07: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