Excel question

Richard DukeNovember 17, 2001

I am using excel XP.

How do you add a value with in a singel cell. When I try say working with cell L12 and I want to add cell L11 plus add a new value to L12,how is this done. When I try Sum(L11+L12) and hit the check mark I get a error. I am trying to add weekly values to a running monthly value in a single cell. Thanks for any help. Richard

Thank you for reporting this comment. Undo
nbosboom_hotmail_com

=sum(L11;L12) for the range of L11 to L12
or
=sum(L11;L39) for the range of L11 to/and L39
(the '='-symbol helps excel to understand you want to do a calculation)

Or to simply add two cells:
=L11+L12

When you type the '='-symbol, simply select the cells you wanna add and hit the enter-button.

This works for excel2000, but i dont think it will differ in XP.

Good luck,

Niels.

P.S. Actually this is a question for the computer-help-forum and not the HTML-forum ;-)

    Bookmark   November 17, 2001 at 11:30AM
Thank you for reporting this comment. Undo
deefla

As to including your "new Value" Did you try?
=sum(L11:L12)*L6 (To multiply) or
=sum(L11:L12)/3 (To divide)
=sum(L11*4)+L12 Depending on where your new value plugs in.

    Bookmark   December 16, 2001 at 9:43PM
Sign Up to comment
More Discussions
How to embed animated Gifs onto GW?
I tried posting the way chuggeryguy which worked for...
ladyrose65
Marble Countertop Help!!
Hi, I have recently decided to purchase a spec home...
monikaxp
E-commerce options?
My niece asked for my help in creating a web site for...
jenn
artwork for new bathroom
I recently remodeled my bathroom and am looking for...
xamxam
CSS3 Image Transforms.
<img width="550px" src="http://chuggerguy.com/pub/forumphotos/images/8start.png"...
Richard (chuggerguy)
© 2015 Houzz Inc. Houzz® The new way to design your home™