Mac Works: Adding Cells that May Contain Text or Numeric Values
  
PSS ID Number: Q102157
Article last modified on 10-22-1998
 
2.0 3.0 4.0
 
MACINTOSH
 

======================================================================
-------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 2.0, 3.0 and 4.0
-------------------------------------------------------------------
 
SUMMARY
=======
 
In Microsoft Works, use the SUM() function to obtain the sum of cells
that may contain either text or numeric values.
 
For example, instead of typing =A1+A2+A3+B5+C2+5, where one or all of
the cells may contain text, enter the following:
 
   =SUM(A1,A2,A3,B5,C2,5)
 
The following is an even simpler method:
 
   =SUM(A1:A3,B5,C2,5)
 
The SUM() function ignores text values and adds only numeric values.
Values passed to the SUM() function can be numbers, individual cell
references, ranges, or other functions.
 
Note: Entering =A1+A2+A3+B5+C2+5 will disregard the cell if any
of the specified cells do not contain numeric values.
 
KBCategory: kbother
KBSubcategory: macworkskb
 
Additional reference words: 2.00 3.00  mac mwksss m_eXcel
======================================================================
Version           : 2.0 3.0 4.0
Platform          : MACINTOSH
Issue type        : kbinfo
=============================================================================
Copyright Microsoft Corporation 1998.