Hi,
Can someone help me on this, trying to sumproduct across multiple sheets using iferror function, but it didn't work.
=IFERROR(SUMPRODUCT(('Welded Asly'!A10:$A$500=F2)*('Welded Asly'!C10:$C$500=D2)*'Welded Asly'!D10:$D$500),SUMPRODUCT((Components!A15:$A$500=F2)*(Components!C15:$C$500=D2)*Components!D15:$D$500))
Regards
Bookmarks