Sumifs totals - how to carry formula to other columns

Options

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!