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!
Answers
-
@alwayslearning I don't know what your formula looks like, but it sounds like all you'd have to do is change the reference to the new column you want to sum and leave the rest the same.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen I was hoping I could write the formula in the first column and then "drag" the formula to the other columns. I thought it would automatically update to reference each new column. But that doesn't work. I copied the formula to every cell of the three rows and 15 columns and then changed each reference. It was time-consuming. Happy New Year!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!