+ Reply to Thread
Results 1 to 3 of 3

Countifs: Way to incorporate an or condition in the list of criteria ranges/criteria?

  1. #1
    Registered User
    Join Date
    09-28-2007
    Posts
    14

    Countifs: Way to incorporate an or condition in the list of criteria ranges/criteria?

    I am using countifs extensively in the spreadsheet - but have a condition that could be solved easily by the ability to incorporate an "or" condition in the criteria list within the function. Is that possible?

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Countifs: Way to incorporate an or condition in the list of criteria ranges/criteria

    http://office.microsoft.com/en-ie/ex...005209029.aspx

    1st hit with Google, using the search term "excel countif with or" returns the above.



    Edit

    Whoops - you said countifS. Try this:

    http://www.google.ie/search?q=excel+...w=1280&bih=639
    Last edited by BB1972; 11-06-2012 at 06:37 PM.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Countifs: Way to incorporate an or condition in the list of criteria ranges/criteria

    I think the way you approach this might differ depending on the nature of the "OR" criteria, how many different conditions are there, are you doing an exact match with criteria or using ">" or "<" type criteria? Some approaches might not be possible depending on your answers so more details please......
    Audere est facere

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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