The first formula will count all occurrences greater than 60 so if you want
to include 60 use =60.

Anyway, let's say that it will return 10

now the second will count all occurrences greater than 180, assume that
there are 4, the difference will be 10-4 which is 6 which is in fact all the
occurrences between 60 and 180. My guess is that you want to include 60 and
should then use =60, if not use 60 and if you don't want to include 180
change 180 to =180 in the second formula

The reason is that you can't use COUNTIF in one fell swoop with AND

It can also be done by using

=SUMPRODUCT(--(Range=60),--(Range<=180))

which is probably more in line with what you thought it would look like




--
Regards,

Peo Sjoblom



"Mitchell_Collen via OfficeKB.com" <u33726@uwe wrote in message
news:73f14f8d3af7f@uwe...
What doe the subtraction sign do in this function? I just notices that the

are facing the same way and I was thinking that it had something to do
with
it. I can't figure out if that is between 60 and 180 or both greater than
60
and 180.

Bob Phillips wrote:
=COUNTIF(AE740:AE863,"60")-COUNTIF(AE740:AE863,"180")

you might want to change the second to = if you want to exclude 180.

Please help me. I am trying to create a function that will count if cell
values are between 60 and 180.
[quoted text clipped - 9 lines]

Thanks, Misty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200706/1