Summing in MS EXCEL 2010 – New Features Unraveled

Microsoft Excel is one of the majorly used tools of MS Office for organizing data and creating graphical statistical analysis. The 2010 professional version of Excel is completely loaded. There are plenty of new intelligent features that make working in Excel more convenient.

Though most of the old functions have been just spruced up and fine tuned, there are new additional features to the existing ones that need to be elaborated and explained for new users. The new SUMIF feature is one of them.

SUM function in Excel 2010

SUM is simply adding the numbers of a column. This is available in the Math and Trig menu of the Formulas ribbon. A dialog box opens when the SUM is clicked on this menu. Once you select the columns to be added, you will get the sum of the column at the bottom. Excel sum function is a fairly simply function.

AutoSum is a shortcut feature to add numbers based on a programmed formula. You can enter the formula that can add the columns or rows or both and give you the sum in the end. The syntax is the same as you would give for SUM. By saving an AutoSum feature, you will be saving time and not be bothered by mundane tasks of column/row addition.

SUMIF function in Excel 2010

This is a new addition feature in this version of Excel. The previously known as conditional sum wizard in excel has been replaced by SUMIF and SUMIFS functions. The former is no longer available in excel 2010, but the functions have been incorporated as the latter.

This SUMIF combines the SUM and the IF functions. The conditional summing is required in cases where sum of particular cases are required, which meet certain criterion. This can be a particular number or a criterion of greater than/lesser than. To carry out this function go to the Math and trig menu and select SUMIF. Select the cells you need to add in the spreadsheet. Enter the criteria for addition (a particular number or a greater than/lesser than criteria or even a name). The sum is displayed at the result cell, adding up only those numbers that fit your criteria.

For example, if you want to find out the sales of red tank tops in a garment store and compare that with sales of blue cardigans, you will have to create a spreadsheet with the required information. The information should be the name of the garment, the sales per day, the price and the money earned from each of the individual products.

Once you do that, to know the money earned from the tank tops and cardigans, enter the criteria as blue cardigan and red tank tops. Select the cell in which the sum should be displayed. Hit enter and your result is ready.
This explains the sum function in Excel 2010.