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

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