Hi Geoff
Try this:
=SUMPRODUCT((A1:A3="CO")*(B1:B3200))
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.
|