PDA

View Full Version : One step, many sum functions

lifeline
2012-02-29, 07:26 AM
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.

abhivics
2012-02-29, 07:48 AM
you can use SUM(B6:H6)..this would sum all the cells which lie between B6 and H6.

I hope this is what you want to ask ??

lifeline
2012-02-29, 09:37 AM
you can use SUM(B6:H6)..this would sum all the cells which lie between B6 and H6.

I hope this is what you want to ask ??

No, that would just get me one sum. I need many individual sums; one per row. Thanks though.

abhivics
2012-02-29, 09:58 AM
you can use SUM(B6:H6)..this would sum all the cells which lie between B6 and H6.

I hope this is what you want to ask ??

Can you please put a snapshot of what you want..? Would be easier for me to understand

lifeline
2012-02-29, 10:16 AM
485

Ok, the spaces in the blue columns are (or should be) the total of the white spaces directly to their left. Each spot in the green column should be the total of the 3 blue columns to its left.

This list goes down about 600 rows. If I have to do that one SUM function at a time I'm going to die.

JoePublic
2012-02-29, 01:30 PM
I'm not sure I see the problem. You enter the SUM formulas in the first row then just fill them down (double-click the bottom right corner of the formula cell).

abhivics
2012-02-29, 06:42 PM
Just add the formulas in the first row and drag the cells down to the 600th row ( as ur req says so). Do it for all the cells which contain formulas in first line. Its done..!!! See the file attached for your perusal..

abhivics
2012-03-01, 05:49 AM
Did it work??