Sumproduct combined with sumif -Two Arrays

[fayo2009]

I need to edit the formulae below to allow the sumproduct use the two arrays.

SUMPRODUCT(SUMIFS('PO1 report'!$AB:$AB,'PO1 report'!$O:$O,$B20,'PO1 report'!$E:$E,E$4,'PO1 report'!$AO:$AO,$A$2:$A$4,'PO1 report'!$G:$G,$A$20:$A$28))

 

[Fluff]

Maybe

=sum(SUMIFS('PO1 report'!$AB:$AB,'PO1 report'!$O:$O,$B20,'PO1 report'!$E:$E,E$4,'PO1 report'!$AO:$AO,$A$2:$A$4,'PO1 report'!$G:$G,torow($A$20:$A$28)))

 

[fayo2009]

Perfect, it worked, many thanks

 

[Fluff]

You;re welcome & thanks for the feedback.