Countif Formula

  • Thread starter Thread starter JKVA
  • Start date Start date
J

JKVA

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
 
Maybe this...

=COUNTIF('Data (2)'!$Y$2:$Y$1508,">=-15")-COUNTIF('Data
(2)'!$Y$2:$Y$1508,">15")
 
That's perfect. I was thinking about a way to enter a range within a single
countif, but this makes sense.
Thanks Much.
 
Back
Top