countif

[Guest]

Hi,

I'm trying to count the number of cells within a column, that fall within a
set range (50-120).

I can create a formula that returns the number of cells which are greater
than 50 (as below) but I'm really struggling when trying to create a formula
to count the number of cells that fall within the range of 50 to 120 ?

=COUNTIF(F2:F126,">50")

This has been driving me made for a few hours now, so any help would be very
gratefully received and probably save my hair line !!

Thanks,
Simon

 

[CLR]

=COUNTIF(A:A,"<=120")-COUNTIF(A:A,"<50")

Vaya con Dios,
Chuck, CABGx3