Excel Function With Multiple Criteria

M

mye0417

Hi,

Can somebody help me on which function do i have to use.

1. I need to count the number of (example 22403248 equivalent to
ANSWER)

then answer should be 3

22403248 ANSWER
22456987 ANSWER
456321547 NO ANSWER
459874561 NO ANSWER
441254789 NO ANSWER
449874562 NO ANSWER
456589874 NO ANSWER
22409874 ANSWER


hoping to get response ..
thank you
 
D

Dnereb

do you mean you need to count all numbers in between 22400000 and
2250000
as being answers?
because I can't find any other characteristic to determine if the
number is an answer.
or do you want to count the the text "ANSWER"
 
B

Bob Phillips

Do you mean

=COUNTIF(B:B,"ANSWER")

or do you need to determine whether it is ANSWER or NO ANSWER?

=COUNTIF(B:B,INDEX(B:B,MATCH(22403248,A:A,0)))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top