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?

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?


.