I have a spreadsheet where I want to sum the values of a few cells in non-congruous columns, and enter the result in the last column of the same row. For example =SUM(B6,H6,L6) would be for row six. Result is in Z6. Pretty simple.
Here's my problem: how can I make that happen in hundreds of rows without having to enter a Sum function for each one? This seems like such a simple thing and yet I can't find anywhere online it is explained. Very frustrating. There's got to be an easier way.
Here's my problem: how can I make that happen in hundreds of rows without having to enter a Sum function for each one? This seems like such a simple thing and yet I can't find anywhere online it is explained. Very frustrating. There's got to be an easier way.