Dear all,
Original Formula:
SUMPRODUCT(SUMIFS(Sales!$H:$H,Sales!$E:$E,OFFSET('Product Portfolio'!$A$1,MATCH($M14,'Product Portfolio'!$A$1:$A$918,0)-1,1,COUNTIF('Product Portfolio'!$A$1:$A$918,$M14),1),Sales!$D:$D,$H14,Sales!B:B,$K14,Sales!$F:$F,$N14))
Revised Formula...