+ Reply to Thread
Results 1 to 5 of 5

How to use Countifs for a condition where multiple string need to be checked ()

  1. #1
    Registered User
    Join Date
    06-19-2016
    Location
    Manipal
    MS-Off Ver
    2013
    Posts
    22

    Lightbulb How to use Countifs for a condition where multiple string need to be checked ()

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,406

    Re: How to use Countifs for a condition where multiple string need to be checked ()

    Thread moved to the other platforms section as it is about Google Sheets functionality.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    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: How to use Countifs for a condition where multiple string need to be checked ()

    Hi,

    I think all you require is to wrap the whole thing in an ARRAYFORMULA function like this
    =arrayformula(sum(countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,{"Return requested","Refund Done","Return Completed","Return Received","Partial Refund"})))
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  4. #4
    Registered User
    Join Date
    06-19-2016
    Location
    Manipal
    MS-Off Ver
    2013
    Posts
    22

    Re: How to use Countifs for a condition where multiple string need to be checked ()

    Hello Friend,
    Thank you very much for your reply.
    I had tried this formula but didn't work. It counted data for the status "Return Requested". (For the first string in the array)

    Then I tried with this formula and has worked.

    =countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Refund Done")+countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Return Completed")+countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Return Received")+countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Partial Refund")

  5. #5
    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: How to use Countifs for a condition where multiple string need to be checked ()

    That is interesting- I have just tried the arrayformula version in Google sheets and it worked for me. Perhaps it is a regional settings issue.

+ 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] Multiple Condition Countifs with Uniqueness as Condition
    By semantics in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-21-2017, 05:21 PM
  2. [SOLVED] Two INDEX conditions to be checked with 'IF' condition
    By LesliePrabakar in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-12-2016, 11:03 AM
  3. [SOLVED] how to use if condition to check whether checkbox is checked
    By Bronx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-12-2016, 02:47 AM
  4. Replies: 1
    Last Post: 01-16-2014, 06:13 PM
  5. Check Box that shows options in Combo Box if Checked, and Hides if Not Checked
    By dumbjodie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2013, 10:06 AM
  6. Replies: 2
    Last Post: 12-19-2012, 11:23 PM
  7. [SOLVED] =COUNTIFS with condition based on length of text string
    By sunsoar77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-25-2012, 02:25 AM

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