View Single Post
  #7  
Old April 19th, 2010, 08:12 PM posted to microsoft.public.excel.worksheet.functions
csmith13
external usenet poster
 
Posts: 4
Default COUNTIF Function

here is my formula. It did not have the absolute value in it.
=COUNTIFS(C24:R24,"=1.0")

"Luke M" wrote:

It would help immensely if you had posted your formula for us to evaluate.
Without it, my best guess would be that your formula currently looks
something like:
=COUNTIF($1:$1,"My value")

when it should be:
=COUNTIF(1:1,"My value")

--
Best Regards,

Luke M
"csmith13" wrote in message
...
I am trying to use the countif function by rows and it is not calculationg
correctly. I try to drag the formula down and it just repeats the same
value
as the origin cell. Is there some type of malfunction with tis function?



.