With Excel you need not have to worry to add up several numbers of figures at a time. Move aside your calculator coz Excel has got tools which provides much easier way to perform mathematical operations rather than using a calculator. No matter if you don’t have any earlier experience and is new to Excel.
All you have to do is to follow some very simple steps which will help you out in creating as well as saving figures in Excel spreadsheet.
Open Microsoft Excel and follow Step 2, 3, 4 whichever is applicable.
If you need to add numbers in adjacent cells than you can use the AutoSum command. AutoSum icon is located in the standard toolbar with a symbol Sigma. In order to do AutoSum, first thing you need to do is to identify the numbers in the rows/columns you want to add and then select the immediate next empty cell of the last figure and then click AutoSum. A formula will appear on the selected cell and the cells within the rows/columns that will be summed up will be highlighted with a blue dotted line. Hit the Enter key and the result will come up on the selected cell. By default the AutoSum command adds all the numbers in the cells that comes before the selected cell so be sure of to tune-up the blue dotted border before hitting enter if you need to select a specific range of data.
If you need to add specific numbers that are located in non-adjacent cells than you can use the Sum command. For this, first select the cell where you need your result and then type the formula “=SUM ()” in the selected cell. You need to type in the cell references you want to add in between the parenthesis, like: =SUM (B2, B4, D6). As you click on the particular cell, you will get its reference in the top left-side below the toolbar of the spreadsheet. Now, hit Enter and you will get the result. If you want to add adjacent cells and want to skip certain cells in between then you need to type “=SUM(B3:B6,B8)” instead AND THEN HIT Enter to get the result. It will sum up the numbers on B3 to B6, will skip B7 and will add B8.
The third function SUMIF is bit complicated. Its purpose too is addition but not like the simple addition in Step 2 and 4. Suppose you have got a list of product types in column A and their prices in column B in you spreadsheet. So now you need to add only the figures which meet a specific condition. In such cases the functions will be written as: =SIMIF (B2:B8,”X”, C2:C8) and hit enter it will show the price of X. B2:B8 is the range to be evaluated; X is the criteria and C2:C8 contains the figures to be added. Condition should always be typed with quotation mark else it will show error.