Countif Formula
in [Functions]
|
From: JKVA on 29 Dec 2009 13:27 I imagine this is a simple question, but I would like to do something like the formula below, but I would like to do it for a range within 15 minutes (+15 or -15 of 0). =COUNTIF('Data (2)'!$Y$2:$Y$1508,">30") Thanks
From: T. Valko on 29 Dec 2009 13:42 Maybe this... =COUNTIF('Data (2)'!$Y$2:$Y$1508,">=-15")-COUNTIF('Data (2)'!$Y$2:$Y$1508,">15") -- Biff Microsoft Excel MVP "JKVA" <JKVA(a)discussions.microsoft.com> wrote in message news:40AD2568-F8B2-43D9-9F51-4D30FAFDB08C(a)microsoft.com... >I imagine this is a simple question, but I would like to do something like > the formula below, but I would like to do it for a range within 15 minutes > (+15 or -15 of 0). > > =COUNTIF('Data (2)'!$Y$2:$Y$1508,">30") > > Thanks
From: JKVA on 29 Dec 2009 16:15 That's perfect. I was thinking about a way to enter a range within a single countif, but this makes sense. Thanks Much. "T. Valko" wrote: > Maybe this... > > =COUNTIF('Data (2)'!$Y$2:$Y$1508,">=-15")-COUNTIF('Data > (2)'!$Y$2:$Y$1508,">15") > > -- > Biff > Microsoft Excel MVP > > > "JKVA" <JKVA(a)discussions.microsoft.com> wrote in message > news:40AD2568-F8B2-43D9-9F51-4D30FAFDB08C(a)microsoft.com... > >I imagine this is a simple question, but I would like to do something like > > the formula below, but I would like to do it for a range within 15 minutes > > (+15 or -15 of 0). > > > > =COUNTIF('Data (2)'!$Y$2:$Y$1508,">30") > > > > Thanks > > > . >
From: T. Valko on 29 Dec 2009 17:52 You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "JKVA" <JKVA(a)discussions.microsoft.com> wrote in message news:DB521355-261A-4B1F-B760-E26836338451(a)microsoft.com... > That's perfect. I was thinking about a way to enter a range within a > single > countif, but this makes sense. > Thanks Much. > > "T. Valko" wrote: > >> Maybe this... >> >> =COUNTIF('Data (2)'!$Y$2:$Y$1508,">=-15")-COUNTIF('Data >> (2)'!$Y$2:$Y$1508,">15") >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "JKVA" <JKVA(a)discussions.microsoft.com> wrote in message >> news:40AD2568-F8B2-43D9-9F51-4D30FAFDB08C(a)microsoft.com... >> >I imagine this is a simple question, but I would like to do something >> >like >> > the formula below, but I would like to do it for a range within 15 >> > minutes >> > (+15 or -15 of 0). >> > >> > =COUNTIF('Data (2)'!$Y$2:$Y$1508,">30") >> > >> > Thanks >> >> >> . >>
|
Pages: 1 Prev: Product Formula Next: #NAME? Error With User Defined Functions |