I want to SUM all row column based on the selected name in the first column, What I've tried is the formula below,but it return me Total = 3 it just return the first value, the result should 5 since I selected named Edwin need help

=SUMIF(A2:A4,"*Edwin*",B2:D4)

CodePudding user response：

Use SUMPRODUCT() instead.

=SUMPRODUCT((B3:D5)*(A3:A5=B8))

For Microsoft-365 you can use FILTER().

=SUM(FILTER(B3:D5,A3:A5=B8))