View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default 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