CountIF Calc

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
Hi
see your other post (and Aladin's answer). In addition you
may consider using a pivot table for this
 
Back
Top