Anytime you can use SUMIF instead of SUMPRODUCT, do it, much less strain on
the sheet performance. Good luck.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Bobberjoe" wrote:

It worked, great. THANKS!
I also got the same result using,
'=SUMPRODUCT(('Sheet1!$E$3:$E$243=400)*('SHEET1'!F 6:F246='SHEET1'!F6:F246)*('SHEET1'!F6:F246))

But your formula I understand how it worked. Thanks, again.
--
Kind Regards,
Bobby