Hi excel experts! I'm trying to use sumifs that contains multiple columns...So I want to get the value highlighted in red if Color1, Color2, and Color3 contains "red", based on its assigned values. I was trying SUMIFS and SUMPRODUCT, but couldn't really figure it out.
<tbody>
</tbody>
code | (columnA) Color1 | (columnB) color1 value | (C) color2 | (D) color2 value | (E) color3 | (F) color3 value | Red | ||
1 | Red | 0.2 | Red | 0.5 | Blue | 0.3 | Sumifs=0.7 | ||
2 | Green | 0.3 | Red | 0.4 | Blue | 0.7 | =0.4 | ||
3 | Green | 0.9 | Red | 0.2 | Green | 0.1 | =0.2 | ||
4 | Red | 0.1 | Blue | 0.2 | Green | 0.3 | =0.1 | ||
5 | Blue | 0.8 | Blue | 0.1 | Blue | 0.2 | =0 |
<tbody>
</tbody>