Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks, that got it working.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count With Date Problem | Excel Worksheet Functions | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count data entries and date problem | Excel Worksheet Functions |