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.
April 5, 2010 at 5:33 PM
nice post keep posting
sargodha board
April 13, 2010 at 12:49 PM
@Amit:
Sure, do let us know what would you like us to give a tutorial on. We will try and get it in one of our future posts.
April 28, 2010 at 7:47 AM
Dummys essentials is the key.Currently I'm running a blog sites that consist of technology questions and concerns
Please posted your comments:
http://geekstalks.blogspot.com/2010/04/understanding-microsoft-excel-2007.html
https://sites.google.com/a/email.phoenix.edu/geeks-blogs/