Hi John

Unless you are using XL2007, you cannot pass whole columns as a
parameter to Sumproduct.
Also, I do not think you can sum across sheets in that way

Try
=SUMPRODUCT((Sheet2!D1:D1000=Sheet1!A3)*(Sheet2!E1 :E1000="Y"))+
SUMPRODUCT((Sheet3!D1:D1000=Sheet1!A3)*(Sheet3!E1: E1000="Y"))


--
Regards

Roger Govier


"John D" wrote in message
...
I have been experimenting with summing accross multiple sheets using
microsoft help for the right formula but I can't get it to work.
This is what I want to do and microsoft helps says it should work this
way.
=SUMPRODUCT(('Sheet2:Sheet3'!D:D=Sheet1!A3)*('Shee t2:Sheet3'!E:E="Y"))
However this is what results every time.
=SUMPRODUCT(('Sheet2:[Sheet3]Sheet3'!D:D=Sheet1!A3)*('Sheet2:[Sheet3]Sheet3'!E:E="Y"))
Can anyone help me please!