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.