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!

Tags:

Best Answer

  • Shubham
    Shubham ✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!