countif
 

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

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

Vaya con Dios,
Chuck, CABGx3



"Snoz" wrote in message
...
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