Results 1 to 29 of 29

countif formula for multiple conditions in the same coloumn

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2014
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    2013
    Posts
    12

    countif formula for multiple conditions in the same coloumn

    Hi All,

    I want to count the number of "a"s and "b"s in column 1 if the relevant column 2 value is equal to "aa" or "bb". please refer below data set. Answer should be 4.

    Here is the formula i used for this,

    =SUMPRODUCT(COUNTIFS(E16:E25,{"aa","bb"},C16:C25,OR("a","b")))

    a - aa
    d - aa
    b - bb
    b - aa
    c - cc
    b - dd
    a - ee
    Last edited by kazun909; 09-12-2014 at 03:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using multiple conditions in formula like countif(), sumif()
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 14
    Last Post: 11-10-2005, 04:10 PM
  2. COUNTIF - multiple conditions
    By allphin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-18-2005, 12:05 PM
  3. Multiple conditions on a countif
    By Mr Mike in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] Multiple conditions on a countif
    By Mr Mike in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  5. Multiple conditions on a countif
    By Mr Mike in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2005, 11:05 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