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

See attachment

Jim Cone
San Francisco, CA

3. ## 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. ## 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. ## 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. ## 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
•