Need to Sum Countif of an entire column when the Smartsheet columns change


We had a procedure that worked well summing an entire column using sum countifs. But we noticed when a new column is added to the referenced sheet it causes the function to break. What other function will work in the same way but also not cause it to break like the current function does when a new column is added.

=SUM(COUNTIFS({Green Range 1}, "Red", {Blue Range 2}, "Yellow"), COUNTIFS({Orange Range 1}, "Red", {Black Range 2}, "Yellow"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!