Results 1 to 8 of 8

Thread: One step, many sum functions

  1. #1

    One step, many sum functions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    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 ??

  3. #3
    Quote Originally Posted by abhivics View Post
    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.

  4. #4
    Quote Originally Posted by abhivics View Post
    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

  5. #5
    Click image for larger version. 

Name:	Screen shot 2012-02-29 at 2.09.17 AM.jpg 
Views:	28 
Size:	22.4 KB 
ID:	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.

  6. #6
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    183
    Articles
    0
    Excel Version
    2010
    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).
    Circumference of a circle = 2πr²



    ²the circle's radius

  7. #7
    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..
    Attached Files Attached Files

  8. #8
    Did it work??

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •