| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| CountIf Function Question | Excel Discussion (Misc queries) | |||
| CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Linear Mode
