Re: Excel v2.1 "Names" ?'s

Article View: comp.sys.ibm.pc

Article #42026

#42026

From: Indra Singhal
Date: Thu, 08 Feb 1990 23:36

14 lines
1129 bytes

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

Technical Details

Message-ID: <29100@amdcad.AMD.COM>

Path:

arc1-ca.pugleaf.net!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

References: <26588@cup.portal.com>

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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

Reply to Parent Message