SUM not totaling negative numbers correctly
I need to use a formula to get the totals for 4 cells that contain formulas. I have used the SUM or AVG function on this sheet for the same purpose and it has worked fine. Now it's not working and I'm wondering if it's because I'm trying to add negative numbers. Anyone know how to correct the total cell formula so it returns the correct total?
1st cell formula (they're all very similar): =SUM(COLLECT({Archive#DaysEarly}, {ArchiveSegment}, HAS(@cell, "XXX")))
Total cell formula (usually works): =SUM(XXX@row:[XXX]@row)
Thank you!
Best Answer

Hi meb_0101
I have tried the sum formula with the same number and it was working fine for me. You can try the below formula
=VALUE(SUM([Column2]@row:[Column3]@row))
Thanks
Shubham Umale, Smartsheet Engineer, Ignatiuz Software
Answers

Hi meb_0101
I have tried the sum formula with the same number and it was working fine for me. You can try the below formula
=VALUE(SUM([Column2]@row:[Column3]@row))
Thanks
Shubham Umale, Smartsheet Engineer, Ignatiuz Software

Thank you, @Shubham
I went to the sheet this morning and it's now correct (without changing the formula). Yesterday must have just been a glitch.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!