A | B | C | D | |
1 | Red | 5 | Red | 1 |
2 | Yellow | 3 | Yellow | 3 |
3 | Blue | 7 | Red | 2 |
4 | Blue | 4 | ||
5 | Red | 2 | ||
6 | Blue | 3 |
<tbody>
</tbody>
The table shows the results I'm trying to achieve. Here's what I tried, but doesn't work:
=SUMIFS($D$1:$D$6,$C:$C,A1)
Edit: The formula would be in column "B" and dragged down for each item in column "A".
Last edited: