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
|