Microsoft Office Package is a very useful software bundle developed by Microsoft for Microsoft Windows as well as Mac OS X. Excel is the spreadsheet application widely used in many areas for calculation purposes, graphing and plotting, data processing. It also supports programming through VBA (Visual Basic for Applications).
To add numbers in excel, we don’t need any knowledge of programming. Use can use one of the following methods according to your requirement.
Brute Force
Formula
In this method, you have to state all the cells you need to
be added manually. Just like in typical addition, the addition operator (+) is
the one you need to use here. Say you want to add the numbers in the cells A1,
A2, A3, A4 and display the total in A5.
Step 1 :
Open Excel in the start menu, from a desktop shortcut.
OR you can hit (Windows + R) from the keyboard simultaneously, type “excel” in the “Run” pop up window and hit Enter (or click on OK).
Step 2 :
Go to the cell you want the addition of the numbers (i.e. A5).
Step 3 :
Type “=A1+A2+A3+A4” and hit enter.
Using
worksheet function SUM()
No programming needed here too, knowing the formula and how
to use it will do the work. For that, we use a worksheet function SUM(). The
syntax for the function is as follows.
Syntax :
SUM(number1, [number2], …)
Eligible Parameters :
Step 1 :
An individual cell
- e.g. SUM(A1)
Multiple cells separated by commas
- e.g. SUM(A1,A2,A4)
A range of cells
- e.g. SUM(A1:A5)
- e.g. SUM(A1:F1)
- e.g. SUM(A1:B5)
A column or a row
- e.g. SUM(A:A)
- e.g. SUM(1:1)
Multiple ranges of cells
- e.g. SUM(A1:A4, C3:C5)
Follow these steps to add numbers using the worksheet
function.
Step 1 :
Open Excel.
Step 2 :
Go to the cell you
want the addition of the numbers.
Step 3 :
Type “=SUM(number1,
[number2], …)” and hit enter.
NOTE: Use the appropriate parameters in the parameter list.
0 comments:
Post a Comment