Dear Readers,Taking into consideration, all the mails that we have been receiving from you, we will be coming up with short and easy tutorials on Microsoft Excel 2007 functions for naïve users. Watch out for our new series.
Let's start by the easiest and most used function: Summation! A simple excel function which most of us use and at the same time this has been a challenge faced by a lot of users who are new to Excel and its features. Let's understand, how you can perform summation of a particular data. Consider the data shown below, as an example.
Now if you want to find out the total amount that is to be paid, you would need to perform the "sum" function. The formula is simple and goes like this (as shown below):=sum(range)
Once the range is selected, then press "enter" on your keyboard and you will get the desired output or the total cost to be paid.
That is all to the SUM function. Shoortcut: The shortcut for the sum function is "Alt + = " (without the quotes). Hitting these keys, will activate the SUM function and select the range, automatically.