Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers between 0 and 2
Hi
Im using networkdays calculation to work out the time between two dates but im having a bit of trouble with a formula to then count these numbers in a different cell. In the other cells i have the specific ranges i need to count so between 0-2 days, 3-5 days and then 6+ days so for the first cell i would assume that i need a formula to count with the criteria being =0 and <=2 then so on. I can get it to work when there is only 1 criteria ie. =COUNTIF(G23:G210,"=6") but cant seem to work it to count the numbers between the two points as above. Many thanks for your help Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count numbers between 0 and 2
Hi Matt
Use sumproduct: =SUMPRODUCT((G23:G210=0)*1,(G23:G210<=2)*1) Regards, Per "tuk16664" skrev i meddelelsen ... Hi Im using networkdays calculation to work out the time between two dates but im having a bit of trouble with a formula to then count these numbers in a different cell. In the other cells i have the specific ranges i need to count so between 0-2 days, 3-5 days and then 6+ days so for the first cell i would assume that i need a formula to count with the criteria being =0 and <=2 then so on. I can get it to work when there is only 1 criteria ie. =COUNTIF(G23:G210,"=6") but cant seem to work it to count the numbers between the two points as above. Many thanks for your help Matt |
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 |