countif function

[Guest]

I want Excel to only count cells with < 3 value. Here is what I used, but
this is wrong. Can anyone tell me what I am doing wrong?
=COUNTIF(('Monitor Tool'!N11:N26,'Monitor Tool'!N20:26)"<" &Data!C1)
Renee

 

[Bob Phillips]

=COUNTIF(('Monitor Tool'!N11:N26,"<"&Data!C1)

COUNTIF only needs a range and a condition


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

I have two ranges, 'Monitor Tool'!N11:N26,'Monitor Tool'!N20:26. I cannot
seem to get the function to work with both of them. It works fine with just
one. Any suggestions?

 

[Bob Phillips]

Do you want to sum one if the other meets the condition? If so, they must be
the same size. If not, what exactly do you want to do?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

No I do not want it to sum. I want both ranges to count the cells with the
#3 (Data!C1) in them.

 

[RagDyeR]

Do you have a typo?
What are your ranges ... exactly?

Your OP formula depicted *overlapping* ranges of
N11:N26
and
N20:26 (?!?!)

So, now you've stated that you want to count cells in 2 ranges that contain
values less then the value in C1.

Fine ... what are your actual ranges?

You could simply combine 2 Countif() functions:

=Countif(range1,"<"&C1)+Countif(range2,"<"&C1)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



No I do not want it to sum. I want both ranges to count the cells with the
#3 (Data!C1) in them.

 

[Guest]

I got it. Thank you RD

Do you have a typo?
What are your ranges ... exactly?

Your OP formula depicted *overlapping* ranges of
N11:N26
and
N20:26 (?!?!)

So, now you've stated that you want to count cells in 2 ranges that contain
values less then the value in C1.

Fine ... what are your actual ranges?

You could simply combine 2 Countif() functions:

=Countif(range1,"<"&C1)+Countif(range2,"<"&C1)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================



No I do not want it to sum. I want both ranges to count the cells with the
#3 (Data!C1) in them.

 

[RagDyer]

You're welcome, and appreciate the feed-back.