Difference between revisions of "Manuals/calci/SUM"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| + | . | ||
| + | |||
| + | |||
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | ||
| − | + | Sum Function:- | |
| − | + | The operation of adding a sequence of numbers; the result is their sum or total | |
</div></div> | </div></div> | ||
| Line 7: | Line 10: | ||
<div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify"> | <div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify"> | ||
| − | + | '''Syntax''' | |
| − | + | SUM(number1, [number2], [number3], [number4], ...) | |
| − | |||
| − | |||
Examples | Examples | ||
</div></div> | </div></div> | ||
| − | + | ||
| − | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' | + | <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div> |
---- | ---- | ||
<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify"> | <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify"> | ||
| Line 27: | Line 28: | ||
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">SUM</font> </font>'''</div></div> | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">SUM</font> </font>'''</div></div> | ||
---- | ---- | ||
| − | <div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> | + | <div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> </font>'''SUM'''(n1,n2, ...) |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | Will calculate total value of parameters n1, n2 etc | |
</div></div> | </div></div> | ||
| Line 45: | Line 40: | ||
</div></div> | </div></div> | ||
---- | ---- | ||
| − | <div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="2"><font color="#484848"><font face="Arial">=SUM(2,4) | + | <div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="2"><font color="#484848"><font face="Arial">=SUM(2,4) = 6</font></font></font> |
| − | =SUM(2,”4”,TRUE) = | + | =SUM(2,”4”,TRUE) = 6 |
</div></div> | </div></div> | ||
| Line 64: | Line 59: | ||
| class=" " | Row1 | | class=" " | Row1 | ||
| class=" " | 2 | | class=" " | 2 | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 3 |
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|- class="even" | |- class="even" | ||
| class=" " | Row2 | | class=" " | Row2 | ||
| − | | class="sshl_f " | | + | | class="sshl_f " | 8 |
| class="sshl_f" | 7 | | class="sshl_f" | 7 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
Revision as of 11:20, 15 November 2013
.
Sum Function:- The operation of adding a sequence of numbers; the result is their sum or total
Syntax
SUM(number1, [number2], [number3], [number4], ...)
Examples
''''''' ''''
Description
SUM
SUM(n1,n2, ...)
Will calculate total value of parameters n1, n2 etc
Adds all the numbers in a range of cells.
=SUM(2,4) = 6
=SUM(2,”4”,TRUE) = 6
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 3 | ||
| Row2 | 8 | 7 | ||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
