1. That formula isn't valid. You're missing some of the parentheses.
Perhaps you intended to say
=SUMPRODUCT(--(Sheet2!A1:A10="apple"),--(Sheet2!B1:B10="orange"),--(Sheet2!C1:C10))
or
=SUMPRODUCT((Sheet2!A1:A10="apple")*(Sheet2!B1:B10 ="orange")*(Sheet2!C1:C10))
?
2.. Yes.
--
David Biddulph

"freebee" wrote in message
...
Hi, I have the following formula in cell A1, sheet 1:
=sumproduct--('sheet2'!a1:a10="apple"),--('sheet2'!b1:b10="orange"),--('sheet2'!c1:c10)
1.how do I simplify this formula
2.can i include another sumproduct formula from sheet 3
Pls. help
Thanks.