Thanks for the help!!!

I don't think this works though?...

Using the =SUMPRODUCT((B1:B5="X")*(C1:C5="Y")) formula you have for finding
which records have X *AND* Y, I get "1"... using my example data, it should
be "2"

Using the =SUMPRODUCT((B1:B5="X")+(C1:C5="Y")) formual you have for finding
which records have X *OR* Y, I get "5"... is should be "4"

Any ideas?

"Franz" wrote:

"MeatLightning" ha scritto nel
messaggio

I have thre columns: One holds names (record keys), another could
hold "X", the last can have a "Y". I want to know how many records
have either an "X" or a "Y" value?

For example:

Column A Column B Column C
Matt X
Bill Y
John X Y
Fred X Y
Tom

How many records (i.e. column A) have either an X or Y?


Supposing your range is A1:B5, you can use this formula:

=SUMPRODUCT((B1:B5="X")*(C1:C5="Y")) to see how many records have eihter X
*and* Y;

or

=SUMPRODUCT((B1:B5="X")+(C1:C5="Y")) to see how many records have either X
*or* Y.

--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------