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

COUNTIF Function
 

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

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