COUNTIF multiple criteria

[SJC]

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.

 

[John C]

Well, to correct your formula, change the <500 to >499 (assuming you want to
exclude the 100 and 500).
So:
=COUNTIF(F309,">100")-COUNTIF(F309,">499")
or....if it is just for a single cell, you could do the following:
=(F309>100)*(F309<500) .... or =AND((F309>100),(F309<500))
or....you could put it in an IF statement
=IF(AND(F309>100,F309<500),1,0)

Hope this helps.

 

[SJC]

Thanks so much for sharing your expertise--the if statement did the trick.