Thread
:
adding name values
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
AKPhil
Posts: n/a
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
Reply With Quote