HOW TO
FIND TOTAL / SUM OF DATA [SCORES] IN EXCEL
Procedures and concepts to consider:
- Have a data into cells [that are to be added] Example 30 + 92 + 14
=SUM(30;92;14)
- Identify the column name and row name
Example
Columns
[B, C and D]
and Row
[2]
…....... Horizontal addition
OR
Column
[B]
and Rows
[2,3,4 and 5]
…........ Vertical addition
- Identify the range of data into cells [that are to be added]
Example B2 to
D2 (B2:D2)
- Syntax: '' = SUM(B2:D2) ''
- Syntax: '' = SUM(B2:B5) ''
NOTE:
In writing formula, use semi-colon [;]
if you use OpenOffice
otherwise use comma only [,]
if you use Microsoft
office
OTHER EXCEL FUNCTIONS [SYNTANX]
No comments:
Post a Comment