View Single Post
  #1   Report Post  
Geoff
 
Posts: n/a
Default 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.