Why use Defined names then? Just use a lookup table and the VLOOKUP() function to connect a letter to a value.

--
Kind regards,

Niek Otten

"AKPhil" wrote in message ...
| Trevor (and Niek and William),
|
| Thanks for the come back.
|
| I do have the letter N in cell K3, letter O in cell K4, and letter M in cell
| K5.
| These letters will change with time, so that is why I assigned number values
| to them. The running total for each row and column will have a consistant
| value.
|
| So, I need to display N,O,M in the cells but need a number at the end
| representing a total.
|
| I tried your suggestions:
|
| =INDIRECT(K3) gives a #REF! error
| same for
| =INDIRECT(K3)+INDIRECT(K4)+INDIRECT(K5)
| and for
| =sum(INDIRECT(K3)+INDIRECT(K4)+INDIRECT(K5))
| and
| =sum(INDIRECT(K3),INDIRECT(K4),INDIRECT(K5))
|
|
| Any other suggestions?
|
| "Trevor Shuttleworth" wrote:
|
| If that's how you've defined the names you would use:
|
| =N+O+M = 100
|
| =INDIRECT(K3) would show 20 if K3 had N in it
|
| =INDIRECT(K3)+INDIRECT(K4)+INDIRECT(K5) = 100
|
| Regards
|
| Trevor
|
|
| "AKPhil" wrote in message
| ...
| Excel 2003
|
| Menu: Insert = Name = Define:
|
| N = 20
| O = 30
| M = 50
|
| Let's say cell(s):
|
| K3 has N displayed
| K4 has O displayed
| K5 has M displayed
|
| =SUM(K3:K5) displays 0
|
| How do I make it display the number 100? As in 20+30+50=100
|
|
|
|
|