LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Multiple low values jdp554 Excel Worksheet Functions 2 October 18th 05 06:55 PM
How can I break values apart that are in the same cell? Phil Excel Worksheet Functions 3 October 4th 05 03:41 PM
Adding large minute and second values eacollins Excel Worksheet Functions 1 September 2nd 05 01:31 AM
Adding Values From Different Tabs Flipkid2 Excel Discussion (Misc queries) 3 August 24th 05 02:23 AM
Adding values from one worksheet to another Richard Thorneycroft Excel Worksheet Functions 0 February 22nd 05 04:07 PM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"