Countif????

V

Vicki Leatherberry

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.
 
B

Bob Phillips

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)
 
Top