+ Reply to Thread
Results 1 to 2 of 2

Countifs formula with specific text that includes parenthesizes problem

  1. #1
    Forum Contributor
    Join Date
    09-08-2016
    Location
    Buffalo, NY
    MS-Off Ver
    365
    Posts
    115

    Countifs formula with specific text that includes parenthesizes problem

    I am using a formula like this in multiple cells and it appears to be working correctly for every other reference except in this case. I am not sure if it is because the cells I am referencing includes parenthesizes in the text.

    =COUNTIFS('Cases Completed'!K:K,[@[Case Type]],'Cases Completed'!J:J,$Q$20)+COUNTIFS('Cases Completed'!K:K,[@[Case Type]],'Cases Completed'!J:J,$Q$21)

    Q20 = FD – Failed to reject/eject (Cash in Check Acceptor)
    Q21 = FD – FD/PF – Failed to reject/eject (Check Failed Business Rule)

    Is it because of the ( ) that my result is coming back 0 even though I do have valid data that meets these criteria? Any advice of how I can accomplish this?

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Countifs formula with specific text that includes parenthesizes problem

    Parenthesis will not make a difference. They are seen as nothing but text.

    It's difficult to give you a working formula when all that we have is a non-working formula.

    Consider uploading a small representative sample of your data along with the desired result (which you can enter manually) based on that sample data.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

+ 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] Problem with countifs formula using two text criteria
    By adam_d_john in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2017, 12:44 PM
  2. Using COUNTIFS to find if a cell includes various dates
    By mmurray2015 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2015, 10:31 PM
  3. Need Help With COUNTIFS Formula That Includes Counting Only Unique Cells
    By Non-Prophet in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2015, 10:40 PM
  4. Countifs includes dates in different format
    By mosheva in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-11-2013, 02:48 AM
  5. SUMIFS formula that includes specific text
    By aurisab in forum Excel General
    Replies: 15
    Last Post: 12-16-2012, 08:20 PM
  6. [SOLVED] Counting Cells that includes exact match and also if a cell includes specific text
    By smclachlan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2012, 07:42 PM
  7. [SOLVED] Formula Problem which includes Sum,If,Frequency,match and row
    By BigH in forum Excel General
    Replies: 2
    Last Post: 02-12-2006, 12:50 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