Count IF problem
 

I have the following numbers in a excel sheet:
45 56 57 60 58 67 50 70 32 65

I want to count the number of numbers that are =50 but <65.
i used =COUNTIF(A3:J3,"<65")-COUNTIF(A1:J3,"<=50") and instead of the
number in the column being 5 it shows as 4.

Did i mess up on the function? Or what?

Any help would be appreciated.

Thanks
Karl

Karl,

You want to count number that are 50 so your ,"<=50" should read ,"<50") and
it will then count 50's

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


wrote in message
ups.com...
I have the following numbers in a excel sheet:
45 56 57 60 58 67 50 70 32 65

I want to count the number of numbers that are =50 but <65.
i used =COUNTIF(A3:J3,"<65")-COUNTIF(A1:J3,"<=50") and instead of the
number in the column being 5 it shows as 4.

Did i mess up on the function? Or what?

Any help would be appreciated.

Thanks
Karl

Thanks, that got it working.