COUNTIF Function
in [Functions]
|
From: csmith13 on 19 Apr 2010 14:14 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?
From: Luke M on 19 Apr 2010 14:21 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" <csmith13(a)discussions.microsoft.com> wrote in message news:9B9ADAAA-C058-4151-877E-D759190078EB(a)microsoft.com... >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?
From: Mitch on 19 Apr 2010 14:31 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?
From: csmith13 on 19 Apr 2010 14:43 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?
From: Mitch on 19 Apr 2010 14:51
just send it to my personal mail: mitch0620(a)hotmail.com 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? |