Snasui Excel Forum

NEED HELP #EXCEL #formulas

To get total of numbers on left column of items mentioned of party / buyers.

please check the attached file for further reference req if any one can help.

Tks

Please provide an example of the correct answer and explain how to think so it will be easier to understand.

Thanks for your response

the criteria and expected results are in the sheet.

Tks

The example formula in B11 is below.

=SUMPRODUCT(SUBTOTAL(9,OFFSET($B$2,ROW($B$2:$B$7)-ROW($B$2),3*(COLUMN($B$1:$H$1)-COLUMN($B$1))))*($A$2:$A$7=$A11)*(SUBSTITUTE(B$10,"TOTAL ","")=T(OFFSET($C$2,ROW($B$2:$B$7)-ROW($B$2),3*(COLUMN($B$1:$H$1)-COLUMN($B$1))))))

Enter and copy to the right then down.

Thanks it is working