Countif Between

[Misterchipper]

How do I do a count if between a certain range?

I.E. I only want to count those records where the cost is greater than 100 and less than or equal to 150?

 

[VoG]

Try

=COUNTIF(A1:A10,">100")-COUNTIF(A1:A10,">150")

 

[Misterchipper]

Jackpot. Thanks boss.

 

[Jonmo1]

Couple ways...

You can use 2 countis..
=COUNTIF(A1:A100,">100")-COUNTIF(A1:A100,">150")

Or perhaps sumproduct
=SUMPRODUCT(--(A1:A100>100),--(A1:A100<=150))

Hope that helps.