Countif Formula
 

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

Countif Formula
 

Maybe this...

=COUNTIF('Data (2)'!$Y$2:$Y$1508,"=-15")-COUNTIF('Data
(2)'!$Y$2:$Y$1508,"15")

--
Biff
Microsoft Excel MVP


"JKVA" wrote in message
...
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

Countif Formula
 

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" wrote in message
...
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


.

Countif Formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"JKVA" wrote in message
...
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" wrote in message
...
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


.