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

bayareavuln

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"))

Paul Newcome

It shouldn't break if your cross sheet references are all single columns selected individually. Are you able to provide some screenshots for context?