countif with 2 criteria
 

I have a countif cell over the range c3:c52, I only want it to count the
numbers if it is <=99.34 and =100.65. It excepts the formula but isn't
recognizing the numbers, I have put 100.8 into cell c3 and it isn't counting.
Any help would be great.

=COUNTIF(C3:C52,AND(C3:C52<="99.34",C3:C52="100.6 5"))

Tim Peter

countif with 2 criteria
 

Try this

=COUNTIF(C3:C52,"<=99.34")+COUNTIF(C3:C52,"=100.6 5")

Mike

"tpeter" wrote:

I have a countif cell over the range c3:c52, I only want it to count the
numbers if it is <=99.34 and =100.65. It excepts the formula but isn't
recognizing the numbers, I have put 100.8 into cell c3 and it isn't counting.
Any help would be great.

=COUNTIF(C3:C52,AND(C3:C52<="99.34",C3:C52="100.6 5"))

Tim Peter

countif with 2 criteria
 

Thanks Mike,

I had just tried that it did work, I appreciate your help.

"Mike H" wrote:

Try this

=COUNTIF(C3:C52,"<=99.34")+COUNTIF(C3:C52,"=100.6 5")

Mike

"tpeter" wrote:

I have a countif cell over the range c3:c52, I only want it to count the
numbers if it is <=99.34 and =100.65. It excepts the formula but isn't
recognizing the numbers, I have put 100.8 into cell c3 and it isn't counting.
Any help would be great.

=COUNTIF(C3:C52,AND(C3:C52<="99.34",C3:C52="100.6 5"))

Tim Peter

countif with 2 criteria
 

Try this:

=COUNTIF(C3:C52,"<=99.34")+COUNTIF(C3:C52,"=100.6 5")

Or, using cell references to hold the boundary values:

A1 = 99.34
A2 = 100.65

=COUNTIF(C3:C52,"<="&A1)+COUNTIF(C3:C52,"="&A2)

--
Biff
Microsoft Excel MVP


"tpeter" wrote in message
...
I have a countif cell over the range c3:c52, I only want it to count the
numbers if it is <=99.34 and =100.65. It excepts the formula but isn't
recognizing the numbers, I have put 100.8 into cell c3 and it isn't
counting.
Any help would be great.

=COUNTIF(C3:C52,AND(C3:C52<="99.34",C3:C52="100.6 5"))

Tim Peter

countif with 2 criteria
 

Glad I could help

"tpeter" wrote:

Thanks Mike,

I had just tried that it did work, I appreciate your help.

"Mike H" wrote:

Try this

=COUNTIF(C3:C52,"<=99.34")+COUNTIF(C3:C52,"=100.6 5")

Mike

"tpeter" wrote:

I have a countif cell over the range c3:c52, I only want it to count the
numbers if it is <=99.34 and =100.65. It excepts the formula but isn't
recognizing the numbers, I have put 100.8 into cell c3 and it isn't counting.
Any help would be great.

=COUNTIF(C3:C52,AND(C3:C52<="99.34",C3:C52="100.6 5"))

Tim Peter