I have the following formulas in the cells,

K3=SUMPRODUCT(--(J3=$F$2:$F$3000),--(K$2=$G$2:$G$3000),$D$2:$D$3000)

L3=SUMPRODUCT(--(J3=$F$2:$F$3000),--(L$2=$G$2:$G$3000),$D$2:$D$3000)

M3=SUMPRODUCT(--(J3=$F$2:$F$3000),--(M$2=$G$2:$G$3000),$D$2:$D$3000)

Where

K2=4

L2=5

M2=6

Can some one help me so that the formula in

K3 gives me all values<=4

L3 gives me all values >4 and <=5

M3 gives me values >5 and <=6

Help will be extremely appreciated.

Regards

Mazher