http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regardless what you say you would still need AND (that's what the * does)

=SUMPRODUCT((A2:A2012000)*(A2:A20<24000)+(B2:B20 125)*(B2:B20<200))

will check those 2 ranges



--


Regards,


Peo Sjoblom






"Krish" wrote in message
...

"Bernard Liengme" wrote:

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$7312000), --($BA$4:$BA$73125),
--($BA$4:$BA$73<200), $AX$4:$AX$73)

May be I did not express clearly in posing the question. I did not want
the AND, because I want to get the results either if $BA125 and $BA<200
OR if $AX12000 and $AX<24000.