Path: utzoo!attcan!uunet!mcsun!ukc!kl-cs!nott-cs!cat.fulcrum.bt.co.uk!masalla.fulcrum.bt.co.uk!axion!axion.bt.co.uk!pwilliam
From: pwilliam@axion.bt.co.uk (Philip Williams)
Newsgroups: comp.sys.ibm.pc
Subject: Re: Excel v2.1 "Names" ?'s
Message-ID: <1990Feb12.100505.13101@axion.bt.co.uk>
Date: 12 Feb 90 10:05:05 GMT
References: <29100@amdcad.AMD.COM> <26588@cup.portal.com>
Sender: news@axion.bt.co.uk
Reply-To: pwilliam@axion.bt.co.uk (Philip Williams)
Organization: British Telecom Research Labs
Lines: 35

In article <29100@amdcad.AMD.COM>, indra@pepsi.amd.com (Indra Singhal) writes:
> 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.
> 
> 
> 

I didn't see the original posting but I've just tried it out on a MAC
running Excel 2.2 and A 386 PC running Excel 2.0 (I think my Excel at
home, on a 386 PC, is 2.1 and I will try that tonight) and thet do not
allow a name with a space in it. If underscores are used it functions
correctly.

I will get back if I find anything different on Excel 2.1

Philip


**********************************************************************
P M Williams                                pwilliams@axion.bt.co.uk
RT3133 British Telecom Research Labs    
Martlesham Heath                           'Phone 0473-642770         
IPSWICH Suffolk UK         Message Pager 4226754 (bureau 0345 333111)

"A foolish consistency is the hobgoblin of little minds .....
                                                Ralph Waldo Emmerson
**********************************************************************