Results 1 to 6 of 6

Thread: Excell XP (XP)

  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excell XP (XP)

    I am kind of new to excell. I want to make a simple spread sheet that will add up my business expenses. Is there an easier formula or way to do it that individually going in each cell and puttin in the formula for the total? For the total using B6+B7+B6
    etc.

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Excell XP (XP)

    See attachment

    Jim Cone
    San Francisco, CA

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excell XP (XP)

    Thanks for great example. I asked my question wrong. I know how to auto sum, but when I make a page using the formula is there an easy way to do a simple adding formula instead of going into each cell on the total line and hand typing =C8+D8 then on the next one =C9+D9 =C10+D10 Thanks for all the help [img]/forums/images/smilies/smile.gif[/img]

  4. #4
    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: Excell XP (XP)

    I assume you mean B6+B7+B8.

    Use the sum function:
    <pre>=Sum(B6:B8)</pre>


    To enter it you can even
    enter "=sum(" then take your mouse and select the range B6:B8, and then put in the closing parenthesis ")"

    Steve

  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: Excell XP (XP)

    Enter the first one
    Then mover the mouse to the lower right corner of the cell (the icon will change to a skinny plus "+") Then drag the cell to the right or to the left and the formulas will "copy" keeping the cell references "relative".

    Steve

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Soldotna, Alaska, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excell XP (XP)

    thanks a million worked like a charm [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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