Path: utzoo!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!uunet!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!brutus.cs.uiuc.edu!apple!sun-barr!decwrl!amdcad!pepsi!indra
From: indra@pepsi.amd.com (Indra Singhal)
Newsgroups: comp.sys.ibm.pc
Subject: Re: Excel v2.1 "Names" ?'s
Message-ID: <29100@amdcad.AMD.COM>
Date: 8 Feb 90 23:36:56 GMT
References: <26588@cup.portal.com>
Sender: news@amdcad.AMD.COM
Reply-To: indra@pepsi.AMD.COM (Indra Singhal)
Organization: Advanced Micro Devices, Inc. Sunnyvale CA
Lines: 14

In article <26588@cup.portal.com> MJB@cup.portal.com (Martin J Brown-Jr) writes:
>
>The formula for B5 could read "=SUM(B2:B4)", which gives correct results.
>BUT the formula for B5 that reads "=SUM(Jan Rent:Jan Util)" does NOT give
>the correct result, it returns the value of the cell to the right of the ":".

I would try not using spaces in the names.. use Jan.Rent or Jan_Rent and
see if the problem persists.



iNDRA | indra@amdcad.AMD.COM (Indra Singhal) (408) 749-5445
      | {ames decwrl apple pyramid sun uunet}!amdcad!indra
      | MS 167; Box 3453; Sunnyvale, CA 94088