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
|