COUNTIF Function

C

csmith13

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

Luke M

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")
 
M

Mitch

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.
 
C

csmith13

how do i send you the file?

Mitch said:
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.
 
D

David Biddulph

Have you got calculation mode set to manual instead of automatic?
But otherwise, tell us the formula and we can see what's wrong.
 
M

Mitch

just send it to my personal mail: (e-mail address removed) or you could just
take a snapshot and paste it here.
 
C

csmith13

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

csmith13

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!
 
D

David Biddulph

Glad it did the trick.

One way that manual can be set is if the first workbook you open in an Excel
session is one which has been saved in manual. Other workbooks opened in
the same session will then be treated as manual.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top