COUNTIF Function
Thanks Dave, works great.
Matt
"Dave F" wrote:
Use SUMPRODUCT:
=SUMPRODUCT(--(A1:A10="Monkeys"),--(B1:B10="Yes")) etc.
Dave
--
Brevity is the soul of wit.
"mpenkala" wrote:
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
|