Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif W/ 2 Criteria | Excel Worksheet Functions | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
countif criteria | Excel Worksheet Functions | |||
Countif w/ Criteria | Excel Worksheet Functions |