Sumifs totals - how to carry formula to other columns


I am using a sumifs formula with the same criteria to total 15 columns on my sheet. How do I carry this formula to other columns to maintain the criteria and sum up the total of the column it was carried to? I saw posts from 2018 saying this wasn't possible. Is there newer information on this? I appreciate any help you can provide. I would rather not have to rewrite the formula for each column. Thanks in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!