# combined two countif functions

1. ## 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. ## 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. ## Re: combined two countif functions

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

--

HTH

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

"Geoff" <geoffreynd@yahoo.com> wrote in message
> 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.
>

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

#### 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