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 |
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 |