In the mainframe report writer I do something like the following


"amount" ( in ) 22,24,30,33.5,40,44 to identify the record if any of those
amounts are found. How do I convert that code to excel since COUNTIF only
allows 1 condition to be met.

--
vickilynn

If you just want to test it then

=IF(ISNUMBER(MATCH(A1,{22,24,30,33.5,40,44},0)),"a ","b")

to count them

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A100,{22,24,30,33.5,40,44},0))) )

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Vicki Leatherberry" wrote in message
...
In the mainframe report writer I do something like the following


"amount" ( in ) 22,24,30,33.5,40,44 to identify the record if any of those
amounts are found. How do I convert that code to excel since COUNTIF only
allows 1 condition to be met.

--
vickilynn

thanks Bob, that was exactly what I needed
--
vickilynn


"Bob Phillips" wrote:

If you just want to test it then

=IF(ISNUMBER(MATCH(A1,{22,24,30,33.5,40,44},0)),"a ","b")

to count them

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A100,{22,24,30,33.5,40,44},0))) )

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Vicki Leatherberry" wrote in message
...
In the mainframe report writer I do something like the following


"amount" ( in ) 22,24,30,33.5,40,44 to identify the record if any of those
amounts are found. How do I convert that code to excel since COUNTIF only
allows 1 condition to be met.

--
vickilynn