Difference between revisions of "Microsoft KB Archive/102157"
(importing KB archive) 
m (X010 moved page Microsoft KB Archive/Q102157 to Microsoft KB Archive/102157 without leaving a redirect: Text replacement  "Microsoft KB Archive/Q" to "Microsoft KB Archive/") 
(No difference)

Latest revision as of 19:13, 12 August 2020
Mac Works: Adding Cells that May Contain Text or Numeric Values
PSS ID Number: Q102157 Article last modified on 10221998
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.