Hi Excel Gurus,
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
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