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?

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" <(E-Mail Removed)> wrote in message
news:9B9ADAAA-C058-4151-877E-(E-Mail Removed)...
>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?

Hi,

why don't you try locking the range with $ signs. Or perhaps you could send
a sample so I could take a look at what you want to do.

"csmith13" wrote:

> 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?

how do i send you the file?

"Mitch" wrote:

> Hi,
>
> why don't you try locking the range with $ signs. Or perhaps you could send
> a sample so I could take a look at what you want to do.
>
> "csmith13" wrote:
>
> > 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?

just send it to my personal mail: (E-Mail Removed) or you could just
take a snapshot and paste it here.

"csmith13" wrote:

> how do i send you the file?
>
> "Mitch" wrote:
>
> > Hi,
> >
> > why don't you try locking the range with $ signs. Or perhaps you could send
> > a sample so I could take a look at what you want to do.
> >
> > "csmith13" wrote:
> >
> > > 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" <(E-Mail Removed)> wrote in message
> news:9B9ADAAA-C058-4151-877E-(E-Mail Removed)...
> >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?
>
>
> .
>

THANK YOU! I had no idea that muy calculation was onmanual. I have never
had that problem before but it was the issue.

Thank you again!

"David Biddulph" wrote:

> Have you got calculation mode set to manual instead of automatic?
> But otherwise, tell us the formula and we can see what's wrong.
> --
> David Biddulph
>
>
> "csmith13" <(E-Mail Removed)> wrote in message
> news:9B9ADAAA-C058-4151-877E-(E-Mail Removed)...
> > 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?
>
>
> .
>