Values

Closed

cow - Feb 19, 2009 at 01:04 PM
tintinpi Posts 7 Registration date Monday January 19, 2009 Status Member Last seen June 3, 2009 - Feb 20, 2009 at 03:16 AM

Hello,
I am trying to get a total in one cell that adds the values of another. Example:

Cell A1 contains 5+1; how do I get Cell B1 to total Cell A1?

Thanks.

Cells b77 b81
Vba colorindex values - Guide
How to copy values from one sheet to another in excel - Guide
Based on the values in cells b77 b81 - Excel Forum
Based on the values in cells b77 b81 c77 ✓ - Excel Forum
Name Values - Excel Forum

1 response

Answer 1 / 1

tintinpi Posts 7 Registration date Monday January 19, 2009 Status Member Last seen June 3, 2009
Feb 20, 2009 at 03:16 AM

hi,
you cannot do this.
you will have to put the "5" in one cell (suppose A1) and the "1" in another cell (suppose B1).
then in a different cell (suppose C1) you type the formula:
=SUM(A1:B1)

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Excel function question

Return Seq Values Until Blank value then return different set of seq values

Code to move rows into another sheet based on certain values

Similar discussions

Subscribe To Our Newsletter!