Results 1 to 4 of 4

Thread: [RESOLVED]Adding entire column in Excel

  1. Jun 15th, 2007, 09:36 AM #1
    fastmaxxcooper
    fastmaxxcooper is offline

    Thread Starter
    New Member
    Join Date
    Jun 2007
    Posts
    14

    [RESOLVED]Adding entire column in Excel

    I have a list so the number of rows will be increasing. I do not want to keep changing the algorithm for the sum so i would like to know one that will include all the number put in the same column. I think I may have done this before but I do not remember what i had done. thanks

    ian
    Last edited by fastmaxxcooper; Jun 15th, 2007 at 08:02 PM. Reason: solved
    Reply With Quote Reply With Quote
  2. Jun 15th, 2007, 09:41 AM #2
    fastmaxxcooper
    fastmaxxcooper is offline

    Thread Starter
    New Member
    Join Date
    Jun 2007
    Posts
    14

    Re: Adding entire column in Excel

    nevermind i figured it out. i just made it a range and i picked a range larger than i knew i would be adding

    Code:
    =SUM(B1:B150)
    Reply With Quote Reply With Quote
  3. Jun 15th, 2007, 03:50 PM #3
    Logophobic
    Logophobic is offline
    Frenzied Member
    Join Date
    Jun 2006
    Posts
    1,098

    Re: Adding entire column in Excel

    Just do this:
    Code:
    =SUM(B:B)
    Reply With Quote Reply With Quote
  4. Jun 15th, 2007, 08:01 PM #4
    fastmaxxcooper
    fastmaxxcooper is offline

    Thread Starter
    New Member
    Join Date
    Jun 2007
    Posts
    14

    Re: Adding entire column in Excel

    thats even better. thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width