name a cell irrespective of its value

[asubrama]

Hi,
i have the following problem

cell A1= 1
cell A2 = 2
cell B1= A1+A2

so cell B1 displays 3

but i want to name the cell B1 as SUM and want it to display as SUM while it should store the value (A1+A2) even as A1 and A2 keep changing. And also use cell B1's value further in other cells for more calculations without affecting its display name SUM. is that possible?

cheers

Ananth

[:) Sixthsense :)]

Place the cursor in B1 Cell and Press Ctrl+F3 and Click New. Enter the Name as Sum and Click Ok and Close.

Place the cursor in B1 Cell and copy paste the below formula

=SUM(A1:A2)

[TheCman81]

You can custom format B1 using "SUM" 0

Is this what you mean?

[Vikas_Gautam]

just select the B1 cell
goto insert ,names and click define...
write SUM and click ok...

B1 will get a name ''Sum" ....

if helped Click *

[asubrama]

Hi,
thanks for the quick reply. i have already tried this but it still not displays "SUM" for some reason. it displays the value on the cell. I call see the name of the cell on the toolbar but on the actual cell

cheers

me

[:) Sixthsense :)]

Oops... I assumed it in some other way..

Leave my earlier post and try this one

In B1 Cell

="Sum " &SUM(A1:A2)

Or

=SUM(A1:A2)&" Sum"

[cbatrody]

Hi,

Something like this?

Regards,
Chandra

[asubrama]

Hi Vikas,
when i open the worksheet i want the cell to display the name "SUM" instead of the value it contains. By following what you sixthsense suggested it still shows the value and not the name. i am using excel 2007

cheers
me

[cbatrody]

Did you check the file I posted?

[asubrama]

Hi cbatrody
thanks for that. but there you have added a extra text box but i would not like to do that.
cheers

ananth

[cbatrody]

Yes, but you can use that cell for calculation purposes & also the cell does not display the value though it has the product (A1*A2) in it

[asubrama]

Dear TheCman81 and Sixthsense,

we are getting closer- with your approach i indeed get the cell to display SUM but it also displays the value of the sum unless i have done something wrong. I would like it to display only SUM while retaining the value of the calculation (=3)

cheers
me

[asubrama]

Hi Cbratrody,

i will keep that as the backup plan if i do not find any other solution

cheers

ananth

[:) Sixthsense :)]

In B1 Cell

=SUM(A1:A2)

Place the cursor in B1 Cell and do right click and select Format Cells>>Number>>Category>>Custom>>Under Type Copy paste the below text

"SUM"

Refer the attached screenshot for more details

[cbatrody]

Please see the attached file.

[asubrama]

Perfect Sixthsense... thanks for the quick help

[asubrama]

and to you Cbatrody

[Vikas_Gautam]

use show formula...
in formula tab...