| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Column A = X, Column B =y count = count +1
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 |
|
#2
|
|||
|
|||
|
Column A = X, Column B =y count = count +1
Hi!
Try this: C1 = zip code D1 = rating =SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1)) Biff "Scott" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
