COUNTIF question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre - 22 Feb 2007 20:24 GMT

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

Reply to this Message

Pierre - 22 Feb 2007 20:28 GMT

> 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
[quoted text clipped - 11 lines]
>
> Pierre

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

Reply to this Message

bj - 22 Feb 2007 21:10 GMT

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

> > 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
[quoted text clipped - 15 lines]
> "N" in all 5.
> Pierre

Reply to this Message

Pierre - 22 Feb 2007 21:25 GMT

> 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

Reply to this Message