SUMPRODUCT with 2 criterias
Here you can learn how to apply SUMPRODUCT
If you don't use AND you can't get 125 AND <200
--
Regards,
Peo Sjoblom
"Krish" wrote in message
...
I created this formula, but it is not working.
=SUMPRODUCT(--($AX$4:$AX$7312000)+--+($BA$4:$BA$73125),
--($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
|