View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DogCrazy DogCrazy is offline
external usenet poster
 
Posts: 1
Default COUNTIF not counting properly

Hello, I hope someone can help!

I am using the following formula: =COUNTIF(AM6:AM105,"=1.0")-(AM112+AM113)

It works great except it will not count any occurance of "1.0". The same
formula for counting "=4.0" picks up both occurances of 4.0. Literally, it
is only 1.0 it refuses to count...help :-)

Thank you all in advance!