+ Reply to Thread
Results 1 to 14 of 14

How do I add together certain cells on a different column but the same line?

  1. #1
    Registered User
    Join Date
    09-27-2014
    Location
    Gravesend, Kent
    MS-Off Ver
    Professional Plus 2013
    Posts
    8

    How do I add together certain cells on a different column but the same line?

    I'm creating a document for my performance in a game and have pretty much no experience in Excel.
    I have a column for 'Total Kills' and and then in different columns I record the results of each game with the 3rd column of each game being my kills. What kind of formula could I use to add together each of the 3rd columns of my game together in a single line and put them in the 'Total Kills' box?
    So far I've been putting these together by hand which takes quiet a while.
    Thanks for the help in advance.
    Here's the example:example.png
    Last edited by crazykilla; 09-27-2014 at 03:05 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    Re: How do I add together certain cells on a different column but the same line?

    Hi crazykilla,

    If I'm understanding your query correctly =Q2+Y2 entered into cell I2 would cover your needs?

    Regards,

    Snook

  3. #3
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: How do I add together certain cells on a different column but the same line?

    Crazykilla, hello.

    If you want to sum all of kills for a Sep-20, then you need to use formula as below. It is Array Formula (must be entered with Ctrl + Shift + Enter). No matter how much games will be to the left - it will SUM it.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    09-27-2014
    Location
    Gravesend, Kent
    MS-Off Ver
    Professional Plus 2013
    Posts
    8

    Re: How do I add together certain cells on a different column but the same line?

    Would there not be an easier way for applying this to more lines? I'd have to change the numbers in the formula in every line.

  5. #5
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    Re: How do I add together certain cells on a different column but the same line?

    I'm not sure what you're asking? Try pressing ALT + = which will start a SUM function, then select the range of cells you wish to add using your mouse. If you wish to sum more than one range of cells hold down CTRL to select multiple ranges.

    Hope this helps?

    Regards,

    Snook

  6. #6
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: How do I add together certain cells on a different column but the same line?

    If you want to apply it to more lines, to different dates - then we may fix one row with "$" symbols. When you will enter this formula to I2 cell (Ctrl + Shift + Enter), then just drag it down as far as you need.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-27-2014
    Location
    Gravesend, Kent
    MS-Off Ver
    Professional Plus 2013
    Posts
    8

    Re: How do I add together certain cells on a different column but the same line?

    When I attempt using this formula I get an error that there is a circular reference and gives a total of 0.

  8. #8
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: How do I add together certain cells on a different column but the same line?

    How far to the right do you have any data?

  9. #9
    Registered User
    Join Date
    09-27-2014
    Location
    Gravesend, Kent
    MS-Off Ver
    Professional Plus 2013
    Posts
    8

    Re: How do I add together certain cells on a different column but the same line?

    The columns are every 8th cell from the total and go on for 4 total games a day.

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How do I add together certain cells on a different column but the same line?

    crazy, I suggest you upload a sample workbook, showing what you have and what you want.

    It sounds like you want to use sumiF() or sumifS(), but Im not going to guess
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #11
    Registered User
    Join Date
    09-27-2014
    Location
    Gravesend, Kent
    MS-Off Ver
    Professional Plus 2013
    Posts
    8

    Re: How do I add together certain cells on a different column but the same line?

    I've attached the document, what I basically want is some formulas to put in the totals that add up the statistics in the games.
    Thanks for the help everyone.
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: How do I add together certain cells on a different column but the same line?

    You will find assimilated formula for kills and deaths in the attachment. Did I make a right guess? =)
    Attached Files Attached Files

  13. #13
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    Re: How do I add together certain cells on a different column but the same line?

    Does it need to be any more complex than this?
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    09-27-2014
    Location
    Gravesend, Kent
    MS-Off Ver
    Professional Plus 2013
    Posts
    8

    Re: How do I add together certain cells on a different column but the same line?

    Thankyou very much. It works really nicely now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-10-2014, 04:09 PM
  2. Information from column to line without shiftting the cells
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-13-2014, 10:55 AM
  3. [SOLVED] Splitting multi-line cells into rows and moving the values into another column
    By Gav74 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2013, 09:59 AM
  4. merging cells prohibits slanting column line?
    By wh3resmycar in forum Excel General
    Replies: 3
    Last Post: 08-04-2010, 08:47 AM
  5. Replies: 0
    Last Post: 08-08-2005, 03:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1