SUMPRODUCT with 2 criterias

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created this formula, but it is not working.
=SUMPRODUCT(--($AX$4:$AX$73>12000)+--+($BA$4:$BA$73>125),
--($BA$4:$BA$73<200))*($AX$4:$AX$73)
The column AX has dollar values and Column BA has number of occurrence.
I want to measure if the occurrence is between the range of 125-200 or if
the dollar value is greater than $ 12,000 but less than $ 24,000. I did not
want the conditions as "AND", which is why I am using + sign. Even though I
did not write the second condition of <$ 24,000, I am hoping some experts
will help me achieve my objective.

Thanks
 
Here you can learn how to apply SUMPRODUCT

If you don't use AND you can't get >125 AND <200


--


Regards,


Peo Sjoblom
 
Bernard Liengme said:
You want the A-values to be greater than 12000, AND the B values to be >125
AND less than 200 so you do want AND
=SUMPRODUCT(--($AX$4:$AX$73>12000), --($BA$4:$BA$73>125),
--($BA$4:$BA$73<200), $AX$4:$AX$73)
Click to expand...
 
Back
Top