Excel Function With Multiple Criteria

  • Thread starter Thread starter mye0417
  • Start date Start date
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
 
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"
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Histogram/Frecuency for Multiple Response Questions 1
Count columns that meet criterias 3
COUNTIFS ? 1
If function confused with 0.1 11
COUNTIF or SUMPRODUCT with Mulitple Criteria 3
Countifs across multiple columns using OR 2
Count Multiple Text Entries 1
countif with multiple criteria 3

Back
Top