Adding multiple SUMPRODUCT?

[stuartmacdonald]

I need to add together the SUMPRODUCT from 5 sheets. I have tried a few things (,, --,+,AND, repeating SUMPRODUCT).

This is what makes most sense to me, but it does not work

=SUMPRODUCT(Sheet1!AK4:AK40,Sheet1!Q4:Q40)+(Sheet2!AK4:AK7,Sheet2!Q4:Q7)+(Sheet3!AJ4:AJ25,Sheet3!Q4:Q25)+('Sheet4'!AM4:A M15,'Sheet4'!Q4:Q15)+(Sheet5!AJ4:AJ12,Sheet5!Q4:Q12)

Any suggestions

 

[Marcelo Branco]

Maybe

=SUMPRODUCT(Sheet1!AK4:AK40,Sheet1!Q4:Q40)+SUMPRODUCT(Sheet2!AK4:AK7,Sheet2!Q4:Q7)+SUMPRODUCT(Sheet3!AJ4:AJ25,Sheet3!Q4:Q25)+SUMPRODUCT(Sheet4!AM4:AM15,Sheet4!Q4:Q15)+SUMPRODUCT(Sheet5!AJ4:AJ12,Sheet5!Q4:Q12)

M.