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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!