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!