🚀 go-pugleaf

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
**********************************************************************