COUNTIF Function
Hey gang,
need a little help - here's my scenario:
Worksheet1
ColumnC contains a list of Company Names
ColumnD contains either 'Yes' or 'No'
On Worksheet2 I would like to Count how many 'Yes' and 'No' each company has.
Example:
ColumnC ColumnD
Monkeys Yes
Tigers Yes
Bears Yes
Bears Yes
Tigers No
Mouse No
Monkeys Yes
Results should show
Monkeys: Yes - 2, No - 0
Tigers: Yes - 1, No - 1
Bears: Yes - 2, No - 0
Mouse: Yes - 0, No - 1
Thanks for your help
Matt
|