+ Reply to Thread
Results 1 to 5 of 5

Countifs not working with 2 criteria

  1. #1
    Forum Contributor
    Join Date
    07-28-2015
    Location
    london
    MS-Off Ver
    Microsoft Office 365
    Posts
    116

    Countifs not working with 2 criteria

    Hi,

    I was trying to find a total base on 2 criteria.

    Say in column C1:C100 is Apple and Column E3:AI100 is APP, when both match and found it will show the value as 1.

    I have the formula but it's giving me a #Value! error unless I have 1 criteria only.

    Please see attached sample I'm trying to get.

    Thanks in advance for your help.

    Sample Count.xlsx

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,229

    Re: Countifs not working with 2 criteria

    With countifs the ranges need to be the same size. Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Countifs not working with 2 criteria

    Is this what you wanted?

    =SUMPRODUCT(($C$3:$C$100=AQ3)*($E$3:$AI$100=AO3))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  4. #4
    Forum Contributor
    Join Date
    07-28-2015
    Location
    london
    MS-Off Ver
    Microsoft Office 365
    Posts
    116

    Re: Countifs not working with 2 criteria

    Hi everyone,

    Thank you very much for your help.

    It is greatly appreciated.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,229

    Re: Countifs not working with 2 criteria

    Glad to help & thanks for the feedback.

+ 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 not working for 2 values, but PIVOT is working fine
    By chaiyya345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2019, 05:44 AM
  2. [SOLVED] SUM(CountIfs not working when using date as a criteria
    By spenny32 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-25-2019, 06:17 PM
  3. [SOLVED] Countifs multiple criteria- criteria if cell is greater than another i adjacent column
    By Sircool1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2018, 11:23 AM
  4. [SOLVED] Countifs not working criteria met
    By dmillsmartclean in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-30-2017, 05:33 AM
  5. Counts with multiple criteria, COUNTIFS not working
    By IbeforeV in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-01-2014, 01:22 PM
  6. [SOLVED] countifs working on extended ranges and different sheets not working
    By etaf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2013, 02:23 PM
  7. Replies: 2
    Last Post: 11-06-2012, 06:40 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