Dark0Prince
Active Member
- Joined
- Feb 17, 2016
- Messages
- 433
=SUM(--(FREQUENCY(IF(JOET!$H$1:$H$49999>=O29),IF(JOET!$H$1:$H$49999<=P29),IF(JOET!$A$1:$A$49999="8568"),IF(JOET!$G$1:$G$49999>=1000),IF(JOET!$G$1:$G$4999<=14999.99)))
I'm trying to turn two sum product formulas into sum frequency ones so it runs better, but don't know how. here are the two I'm trying to change and above is my lousy attempt.
=SUMPRODUCT(--(JOET!$H$1:$H$49999>=O30),--(JOET!$H$1:$H$49999<=P30),--(JOET!$A$1:$A$49999="8568"),--(JOET!$G$1:$G$49999>=1000),--(JOET!$G$1:$G$49999<=14999.99))
=SUMPRODUCT(--(JOET!$H$1:$H$49999>=O29),--(JOET!$H$1:$H$49999<=P29),--(JOET!$A$1:$A$49999="8568"),--(JOET!$G$1:$G$49999<=1000))
I'm trying to turn two sum product formulas into sum frequency ones so it runs better, but don't know how. here are the two I'm trying to change and above is my lousy attempt.
=SUMPRODUCT(--(JOET!$H$1:$H$49999>=O30),--(JOET!$H$1:$H$49999<=P30),--(JOET!$A$1:$A$49999="8568"),--(JOET!$G$1:$G$49999>=1000),--(JOET!$G$1:$G$49999<=14999.99))
=SUMPRODUCT(--(JOET!$H$1:$H$49999>=O29),--(JOET!$H$1:$H$49999<=P29),--(JOET!$A$1:$A$49999="8568"),--(JOET!$G$1:$G$49999<=1000))