Formulas_add random cells to a total


I'm trying to create a formula that adds together random cell totals together in a column.. what should the formula look like?


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Are you adding cells from the same row together? Or from different rows? There are a few different ways you can do this... 

    You can either Sum a range of cells that are beside each other... 

    • =Sum [Column Name 1]:[Last Column Name]

    Or you can manually add cell values using basic math. 

    • =[Column Name]@row+ [Different Column Name]@row + [Another Column Name]@row

    If you're summing differnt rows, replace @row with the row numbers. 

  • premiersbobj

    Beautiful!! Thank you.. manual works for this scenario..




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!