+ Reply to Thread
Results 1 to 3 of 3

combined two countif functions

  1. #1
    Geoff
    Guest

    combined two countif functions

    I want to have a table as such:

    state population

    CO 100
    NE 200
    CO 300

    I want to count the number of times state is CO and Population is >
    200. In the example it should result in a count of 1.

    How do i formulate this?

    thanks.


  2. #2
    Michael
    Guest

    RE: combined two countif functions

    Hi Geoff
    Try this:

    =SUMPRODUCT((A1:A3="CO")*(B1:B3>200))

    HTH
    Michael Mitchelson


    "Geoff" wrote:

    > I want to have a table as such:
    >
    > state population
    >
    > CO 100
    > NE 200
    > CO 300
    >
    > I want to count the number of times state is CO and Population is >
    > 200. In the example it should result in a count of 1.
    >
    > How do i formulate this?
    >
    > thanks.
    >
    >


  3. #3
    Bob Phillips
    Guest

    Re: combined two countif functions

    =SUMPRODUCT(--(A2:a100="CO"),--(B2:B100>200))

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Geoff" <[email protected]> wrote in message
    news:[email protected]...
    > I want to have a table as such:
    >
    > state population
    >
    > CO 100
    > NE 200
    > CO 300
    >
    > I want to count the number of times state is CO and Population is >
    > 200. In the example it should result in a count of 1.
    >
    > How do i formulate this?
    >
    > thanks.
    >




+ 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