COUNTIF question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Have a spread*** 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

.

Quantcast