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.

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

=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
news:1123799814.349675.3510@g43g2000cwa.googlegroups.com...
> 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.
>