Return to the Web Authoring Forum | Post a Follow-Up

 o
Excel question

Posted by
Richard Duke
(rduke25@home.com) on
Sat, Nov 17, 01 at 9:42

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


Follow-Up Postings:

 o
RE: Excel question

=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 ;-)


 o
RE: Excel question

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.


 o Post a Follow-Up

Please Note: Only registered members are able to post messages to this forum.

    If you are a member, please log in.

    If you aren't yet a member, join now!


Return to the Web Authoring Forum

Information about Posting

  • You must be logged in to post a message. Once you are logged in, a posting window will appear at the bottom of the messages. If you are not a member, please register for an account.
  • Please review our Rules of Play before posting.
  • Posting is a two-step process. Once you have composed your message, you will be taken to the preview page. You will then have a chance to review your post, make changes and upload photos.
  • After posting your message, you may need to refresh the forum page in order to see it.
  • Before posting copyrighted material, please read about Copyright and Fair Use.
  • We have a strict no-advertising policy!
  • If you would like to practice posting or uploading photos, please visit our Test forum.
  • If you need assistance, please Contact Us and we will be happy to help.


Learn more about in-text links on this page here