how define variables in number format and then sum those values

Hi guys, I need make this:

I have those values: 298, 345, 675, 236. Now I need define to this another number, like this:
1 = 298
2 = 345
3 = 675
4 = 236

So, when I type in cell "1", in reality this is 298, but in cell it should be not visible like 298, just 1. And then maybe under that cell in new cell if I write 3 and this cell would be display 3 but in background it would mean 675. And then I want make SUM, so in our example SUM of those two cells with 1 and 3 displayed, but I want in this SUM cell to be displayed not 4, but 973, so it should sums value of 1 and 3, so 298+675.

I really can not understant how I can make this and I thank you in advance for helping me! Appreciate it!

You could do it using defined named ranges, but in Excel the name cannot be a number, so set those values on the left to _1, _2, _3, _4. You can then use Name manager to allocate those names to the cells next to them.

Suppose you then put _2 in A7 and _4 in A8, then you could use this formula to add the underlying values together:

=SUM(INDIRECT(A7),INDIRECT(A8))

I'm not sure why you would want to go to all that trouble, but hope this helps.

Pete

EDIT: By the way, you may need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Pete