View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tpeter tpeter is offline
external usenet poster
 
Posts: 74
Default 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