Sum if with a logical argument



I'm trying to create a formula that Sums with two criteria, but one of those can change because references to the number of the product we are tracking. It's possible some how to make this info change automaticly so I don't have to change the formula manually after every product change?

=SUMIFS({Apontamento 77.4 P5 Tip Range 4}, {Apontamento 77.4 P5 Tip Range 5}, "1", {Apontamento 77.4 P5 Tip Range 6}, "Upwind")

(Yellow = product info)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!