Hello - first time poster! Looking to do a sumifs with the below so that I can sum just the Blue house in 2018 (answer would be 25.00). I want to be able to use this formula to change the color criteria and year criteria. thank you in advance!!
[TABLE="width: 350"]
<tbody>[TR]
[TD="align: right"]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]House[/TD]
[TD]2017*[/TD]
[TD]2018[/TD]
[TD]2019[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD] blue[/TD]
[TD] 1.00 [/TD]
[TD] 25.00 [/TD]
[TD] 24.00 [/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD] yellow[/TD]
[TD] 10.00 [/TD]
[TD] 30.00 [/TD]
[TD] 74.00 [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD] green[/TD]
[TD] 15.00 [/TD]
[TD] 34.00 [/TD]
[TD] 4.00 [/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD] pink[/TD]
[TD] 20.00 [/TD]
[TD] 39.00 [/TD]
[TD] 48.00 [/TD]
[/TR]
</tbody><colgroup><col span="2"><col span="3"></colgroup>[/TABLE]
[TABLE="width: 350"]
<tbody>[TR]
[TD="align: right"]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]House[/TD]
[TD]2017*[/TD]
[TD]2018[/TD]
[TD]2019[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD] blue[/TD]
[TD] 1.00 [/TD]
[TD] 25.00 [/TD]
[TD] 24.00 [/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD] yellow[/TD]
[TD] 10.00 [/TD]
[TD] 30.00 [/TD]
[TD] 74.00 [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD] green[/TD]
[TD] 15.00 [/TD]
[TD] 34.00 [/TD]
[TD] 4.00 [/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD] pink[/TD]
[TD] 20.00 [/TD]
[TD] 39.00 [/TD]
[TD] 48.00 [/TD]
[/TR]
</tbody><colgroup><col span="2"><col span="3"></colgroup>[/TABLE]