Sumproduct Instead Of Sumif - Sumif Has Index-Match?

[emus007]

Hi,

I'm wanting to use the sumproduct function for this formula instead of the sumif formula because it doesn't work when referencing an external workbook.
=SUMIF('[01-Payroll Cost Summary.xlsx]Labour-Total'!$B$5:$B$56,$P$2,INDEX('[01-Payroll Cost Summary.xlsx]Labour-Total'!$C$4:$X$56,0,MATCH($K5,'[01-Payroll Cost Summary.xlsx]Labour-Total'!$C$4:$X$4,0)))

How would I write the index-match part of the formula? I believe the first array would simply be: ('[01-Payroll Cost Summary.xlsx]Labour-Total'!$B$5:$B$56=$P$2).

Thanks,
Elu

 

[Andrew Poulsom]

Is it?

=SUMPRODUCT(--('[01-Payroll Cost Summary.xlsx]Labour-Total'!$B$5:$B$56=$P$2),INDEX('[01-Payroll Cost Summary.xlsx]Labour-Total'!$C$5:$X$56,0,MATCH($K5,'[01-Payroll Cost Summary.xlsx]Labour-Total'!$C$4:$X$4,0)))

 

[emus007]

Thanks Andrew - that wasn't hard at all.

Very much appreciated.