Formulas_add random cells to a total

premiersbobj

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

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..

 

Bob