Try it like this:

=--AND(F309100,F309<500)

count if the cell is between 100 and 500

99 times out of 100 when someone says that what they really mean is greater
than or equal to 100 and less than or equal to 500. So, just in case:

=--AND(F309=100,F309<=500)

--
Biff
Microsoft Excel MVP


"SJC" wrote in message
...
I am having trouble with a formula that will count if two criteria are
true,
so that I want it to count if the cell is between 100 and 500. Right now,
here is the formula I am using, but it does not work.

=COUNTIF(F309,"100")-COUNTIF(F309,"<500")

Any help would be greatly appreciated.