View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKPhil
 
Posts: n/a
Default adding name values

Excel 2003

Menu: Insert = Name = Define:

N = 20
O = 30
M = 50

Lets 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