software

In the mainframe report writer I do something like the followingquot;amountquot; ( 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)),quot;a quot;,quot;bquot;)

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)

quot;Vicki Leatherberryquot; gt; wrote in message
...
gt; In the mainframe report writer I do something like the following
gt;
gt;
gt; quot;amountquot; ( in ) 22,24,30,33.5,40,44 to identify the record if any of those
gt; amounts are found. How do I convert that code to excel since COUNTIF only
gt; allows 1 condition to be met.
gt;
gt; --
gt; vickilynn
thanks Bob, that was exactly what I needed
--
vickilynnquot;Bob Phillipsquot; wrote:

gt; If you just want to test it then
gt;
gt; =IF(ISNUMBER(MATCH(A1,{22,24,30,33.5,40,44},0)),quot;a quot;,quot;bquot;)
gt;
gt; to count them
gt;
gt; =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A100,{22,24,30,33.5,40,44},0))) )
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Vicki Leatherberryquot; gt; wrote in message
gt; ...
gt; gt; In the mainframe report writer I do something like the following
gt; gt;
gt; gt;
gt; gt; quot;amountquot; ( in ) 22,24,30,33.5,40,44 to identify the record if any of those
gt; gt; amounts are found. How do I convert that code to excel since COUNTIF only
gt; gt; allows 1 condition to be met.
gt; gt;
gt; gt; --
gt; gt; vickilynn
gt;
gt;
gt;