On Feb 22, 2:24 pm, "Pierre" wrote:
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

Sorry for the inconsistancy. . .the ones I want to count could have an
"N" in all 5.
Pierre