COUNTIF Function
in [Functions]
|
From: "David Biddulph" groups [at] on 19 Apr 2010 14:50 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" <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: csmith13 on 19 Apr 2010 15:12 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" <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: csmith13 on 19 Apr 2010 15:31 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" <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: "David Biddulph" groups [at] on 19 Apr 2010 16:06
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. -- David Biddulph "csmith13" <csmith13(a)discussions.microsoft.com> wrote in message news:B3A54A06-1D01-457B-93E2-AE939DB906AD(a)microsoft.com... > 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" <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? >> >> >> . >> |