+ Reply to Thread
Results 1 to 3 of 3

How do I count based on two conditions?

  1. #1
    Mark G
    Guest

    How do I count based on two conditions?

    Hi there. I have a long lists of data to sort though and I am trying to write
    a formula that counts that number of entries for a company with a certain
    condition entered in another column. For instance

    Company name Condition
    Big Corp operatonal
    Small corp operational
    Big Corp non-operational

    How do I count where Big Corp is operational and where it is non-operational?

    Thanks,
    Mark

  2. #2
    Anne Troy
    Guest

    Re: How do I count based on two conditions?

    Try this, Mark:
    http://www.officearticles.com/excel/...soft_excel.htm
    ************
    Hope it helps!
    Anne Troy
    www.OfficeArticles.com

    "Mark G" <Mark [email protected]> wrote in message
    news:[email protected]...
    > Hi there. I have a long lists of data to sort though and I am trying to
    > write
    > a formula that counts that number of entries for a company with a certain
    > condition entered in another column. For instance
    >
    > Company name Condition
    > Big Corp operatonal
    > Small corp operational
    > Big Corp non-operational
    >
    > How do I count where Big Corp is operational and where it is
    > non-operational?
    >
    > Thanks,
    > Mark




  3. #3
    Max
    Guest

    Re: How do I count based on two conditions?

    Another option is to use SUMPRODUCT ..

    Assuming source table is within A1:B100,
    data from row2 down

    Placed
    In D2 down: Big Corp, Small Corp, etc (i.e. company names)
    In E1: operational
    In F1: non-operational

    (Ensure the names / words match exactly with those within the source table.
    Check spelling and spaces, etc.)

    Then we could put in E2:
    =SUMPRODUCT(($A$2:$A$100=$D2)*($B$2:$B$100=E$1))
    Copy E2 to F2, and fill down to populate the table

    Note that we can't use entire col references (eg: A:A, B:B, etc) in
    SUMPRODUCT
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---
    "Mark G" <Mark [email protected]> wrote in message
    news:[email protected]...
    > Hi there. I have a long lists of data to sort though and I am trying to

    write
    > a formula that counts that number of entries for a company with a certain
    > condition entered in another column. For instance
    >
    > Company name Condition
    > Big Corp operatonal
    > Small corp operational
    > Big Corp non-operational
    >
    > How do I count where Big Corp is operational and where it is

    non-operational?
    >
    > Thanks,
    > Mark




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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