In K3: =N

Use the = sign to get the value of the defined name.

--
Kind regards,

Niek Otten

"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
|
|