'SUM all row based on selected name First Column in Excel
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)
Solution 1:[1]
Use SUMPRODUCT() instead.
=SUMPRODUCT((B3:D5)*(A3:A5=B8))
For Microsoft-365 you can use FILTER().
=SUM(FILTER(B3:D5,A3:A5=B8))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Harun24hr |