Excel Function With Multiple Criteria
 

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


--
mye0417
------------------------------------------------------------------------
mye0417's Profile: http://www.excelforum.com/member.php...o&userid=26124
View this thread: http://www.excelforum.com/showthread...hreadid=396756

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"


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=396756

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)


"mye0417" wrote in
message ...

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


--
mye0417
------------------------------------------------------------------------
mye0417's Profile:
http://www.excelforum.com/member.php...o&userid=26124
View this thread: http://www.excelforum.com/showthread...hreadid=396756