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

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

something like
=sumproduct(--(C1:C2500="N"),--(D1:D2500="N"),--(E1:E2500="N"),--(F1:F2500="N"),--(G1:G2500="N"))

will give you the count of all those with all Ns
"Pierre" wrote:

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

On Feb 22, 3:10 pm, bj wrote:
something like
=sumproduct(--(C1:C2500="N"),--(D1:D2500="N"),--(E1:E2500="N"),--(F1:F2500=*"N"),--(G1:G2500="N"))

will give you the count of all those with all Ns




bj,
That did the trick marvelously, thanks for your knowledge.

Pierre