I am trying to create a formula that will count the number of times two
conditions are met. In the fist column, zip codes, in the second column
rating( 1-5 ). I want to know the number of times zip code 99999 is rated 9.

Column A Column B
99999 9 <---like this.....count gets +1
88888 7 <---not this......count gets +0


--
Scott Miller
University of Washington
Chemistry