COUNTIF question

P

Pierre

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
 
P

Pierre

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
Click to expand...

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

bj

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
 
P

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
Click to expand...

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

Pierre
 
Top