Results 1 to 9 of 9
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: formula to add cloumns together (2003)

    Welcome to Woody's Lounge!

    Do you want a grand total in - say - G1, or do you want a row total in each appropriate cell in column G?

    Are there other data below the data you want to add together?

  2. #2
    New Lounger
    Join Date
    Jan 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula to add cloumns together (2003)

    row total in each appropriate cell in column G please

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: formula to add cloumns together (2003)

    in G1 enter:
    <pre>=SUM(A1:F1)</pre>



    then copy G1 down the rows

    Steve

  4. #4
    New Lounger
    Join Date
    Jan 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula to add cloumns together (2003)

    is there a formoula so i dont have to copy and paste down G?

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: formula to add cloumns together (2003)

    You can got to the bottom right corner of the cell and when the cursor changes to a "+" you can dbl-click and it will autofill down the rows.

    If that is not what you are after could you elaborate?

    Steve

  6. #6
    New Lounger
    Join Date
    Jan 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula to add cloumns together (2003)

    i want to make a spread sheet to check addition on tickets.
    i need to be able to enter the prices in each row then check the total with the total on my ticket.
    i was wondering if there was a way to be able to just add the coulmns and show the answer regardless of how many rows it is?
    or am i not making any sence?

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: formula to add cloumns together (2003)

    If you want the "grand total" you can do it with the formula:

    <pre>=SUM(A:F)</pre>


    But you indicated individual rows.
    Without copying the formula down all the rows, you can get an individual row using the offset function, (this assumes the row# you are interested in is put in cell H1:

    <pre>=SUM(OFFSET($A$1,H1-1,0,1,5))</pre>


    If that is not what you are after, you will have to elaborate.

    Steve

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formula to add cloumns together (2003)

    You can put Steve's formula [=SUM(A1:F1)] in cell G1 and copy it down past the rows that have any data in A:F. The formula will show a 0 result until you enter numeric data in any of the columns A:F at which time it will show the sum of the numeric cells. If you don't want the 0 to display before you enter any data in A:F, then you can change the formula to:

    <pre>=IF(COUNT(A1:F1)>0,SUM(A1:F1),"")
    </pre>


    Then copy that down.
    Legare Coleman

  9. #9
    New Lounger
    Join Date
    Jan 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formula to add columns together (2003)

    What is the formula to add column a+b+c+d+e+f and the total to appear in g
    The row numbers are changing it depends on the number of tickets i have to total.
    please help me.

Posting Permissions

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