CountIF Calculations

[Michael]

Hi Folks - Here's my scenario:

Code Answer
3 Yes
3 No
3 Maybe
4 No
3 No
4 Maybe
4 Yes
3 Yes


I need a way to count the number of Yes', No's and Maybe's for each code
type, like this:

Yes No Maybe
3 2 2 1
4 1 1 1

Thanks for your help!

Michael

 

[Aladin Akyurek]

Let A2:B8 house the sample you provided.

=SUMPRODUCT(--($A$2:$A$8=E2),--($B$2:$B$8=F2))

where E2 houses a code of interest and F2 a value like Yes.

 

[kim lawley]

or a simple pivot table would do the job - answer as
collums, code as rows with a count of answer as the data