Counting values between 70 and 140

[Erin]

I'm creating a worksheet that requires a function that counts the number of
values between 70 and 140.

I've tried =COUNTIF(U60:AM90,">70")-COUNTIF(U60:AM90,"<140") however this
duplicate counts the over 70 group.

Any help would be appreciated!
Erin

[Govind]

Hi,

A simple change would fix this

=COUNTIF(U60:AM90,">70")-COUNTIF(U60:AM90,">140")

IN the first countif, you count everything above 70 (which would also
include values above 140) and in second countit you reduce the values
which are above 140. so the net result is values between 70 and 140.

Regards

Govind.

Erin wrote:
> I'm creating a worksheet that requires a function that counts the number of
> values between 70 and 140.
>
> I've tried =COUNTIF(U60:AM90,">70")-COUNTIF(U60:AM90,"<140") however this
> duplicate counts the over 70 group.
>
> Any help would be appreciated!
> Erin