countif

[Snoz]

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



"Snoz" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>