+ Reply to Thread
Results 1 to 2 of 2

Criteria in COUNTIFS

  1. #1
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Criteria in COUNTIFS

    Hi,
    In this thread i took notice then "" and "=""" are not the same, and checked it up. In column C there are nulls, null strings ("") and empty cells. It does not matter if count nulls. But with empty and "" there are variations. I can not interpret it.

    MS function help
    Attached Files Attached Files
    Last edited by tim201110; 07-19-2017 at 11:10 AM.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Criteria in COUNTIFS

    "=""" is looking for cells with " in them.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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] COUNTIFS with Multiple Text Criteria in Same Criteria Range
    By xl2016 in forum Excel General
    Replies: 5
    Last Post: 06-18-2017, 05:00 AM
  2. Countifs with multiple criteria in single criteria range
    By SUHAS KARHADKAR in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-01-2016, 10:55 AM
  3. Countifs with multiple criteria in single criteria range
    By MCP313 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2016, 03:51 AM
  4. [SOLVED] COUNTIFS with multiple criteria in the same criteria range
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2015, 01:04 PM
  5. [SOLVED] Countifs multiple criteria, and 1 criteria Less than & Greater than
    By david gonzalez in forum Excel General
    Replies: 4
    Last Post: 06-30-2014, 10:33 PM
  6. [SOLVED] Countifs with multiple criteria and one criteria has a list of names
    By Beefy1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2014, 05:25 PM
  7. Replies: 2
    Last Post: 11-06-2012, 06:40 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