Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Have a spreadsheet containing vendor names in column A, and the column
headings of C,D,E,F and G contain criteria names for evaluating them in a number of ways. All data then entered in these columns C,D, E, F, or G contain either the letter "Y", or an "N". Am looking for a count of the number of vendors which have "N" in all of the 5 categories. IOW, how many vendors have the letter "Y" in all 5 of the 5 columns C,D,E,F,G. The data containing vendors goes to about 2200 rows. Thanks for your help on this head-scratcher. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF Question | Excel Worksheet Functions | |||
CountIf Question | Excel Discussion (Misc queries) | |||
Countif question | Excel Worksheet Functions | |||
countif question | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions |