Column A = X, Column B =y count = count +1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count If Column A = x and Column B = y 18
Count column b if column a equal cell value 7
how to count#cells w/= value in other column and not count blank c 4
Complex Count formula 17
Count if dates meet certain criteria 10
Excell - two conditions count if factors are true when negative nu 2
Counting latest date in two columns 7
How do I count only if either/ or exist 5

Back
Top