Sumproduct(sumif(indirect

[jmcgallan]

Hello,

I'm having issues using the SUMPRODUCT function in Excel.

I am attempting to creat a summary sheet to calcualte total spends for different parts of the business.

In this example i have my summary sheet with the business codes in Column A. In sheets 2 & 3 i have the spends against each code. Each code can apeear multiple time on both sheets. See attached

On the summary page i have created a range for my tab names 'SheetList02' and am trying to use the following formula in cell D1...but unsucessfully

=SUMPRODUCT(SUMIF(INDIRECT("'"SheetList02"'!A1:B7"),A9,INDIRECT("'"SheetList02"'!B1:B7")

Can someone help?

Many thanks