| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers
say 1400 & <1500 in a range from 1200 to 1600
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers
Try this:
=COUNTIF(range,"1400") - COUNTIF(range,"<1500") Hope this helps. Pete On Aug 26, 9:27*am, T3 wrote: *say 1400 & <1500 in a range from 1200 to 1600 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers
Cheers Pete
But this counts all numbers above 1400 and then all numbers below 1500 and the difference could be a negative value, its the number of numbers between the two values. "T3" wrote: say 1400 & <1500 in a range from 1200 to 1600 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers
Hi T3,
I'm sure it was just a typo, Pete meant =COUNTIF(range,"1400") - COUNTIF(range,"1500") Depending on your requirements you may also need =COUNTIF(range,"=1400") - COUNTIF(range,"=1500") or some other slight variant HTH Martin "T3" wrote in message ... Cheers Pete But this counts all numbers above 1400 and then all numbers below 1500 and the difference could be a negative value, its the number of numbers between the two values. "T3" wrote: say 1400 & <1500 in a range from 1200 to 1600 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers
.... or even
=COUNTIF(range,"1400") - COUNTIF(range,"=1500") <bg -- __________________________________ HTH Bob "MartinW" wrote in message ... Hi T3, I'm sure it was just a typo, Pete meant =COUNTIF(range,"1400") - COUNTIF(range,"1500") Depending on your requirements you may also need =COUNTIF(range,"=1400") - COUNTIF(range,"=1500") or some other slight variant HTH Martin "T3" wrote in message ... Cheers Pete But this counts all numbers above 1400 and then all numbers below 1500 and the difference could be a negative value, its the number of numbers between the two values. "T3" wrote: say 1400 & <1500 in a range from 1200 to 1600 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers
Thanks all,
Worked perfectly. T3 "T3" wrote: say 1400 & <1500 in a range from 1200 to 1600 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count numbers
LOL
I'd like to claim typo too, but probably more likely the beer. <g Cheers Martin "Bob Phillips" wrote in message ... ... or even =COUNTIF(range,"1400") - COUNTIF(range,"=1500") <bg -- __________________________________ HTH Bob "MartinW" wrote in message ... Hi T3, I'm sure it was just a typo, Pete meant =COUNTIF(range,"1400") - COUNTIF(range,"1500") Depending on your requirements you may also need =COUNTIF(range,"=1400") - COUNTIF(range,"=1500") or some other slight variant HTH Martin "T3" wrote in message ... Cheers Pete But this counts all numbers above 1400 and then all numbers below 1500 and the difference could be a negative value, its the number of numbers between the two values. "T3" wrote: say 1400 & <1500 in a range from 1200 to 1600 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count numbers and non numbers(conditional values) | Excel Discussion (Misc queries) | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Linear Mode
