Darpan Sharma

Hello Guys,

Today lets discuss something worthwhile, beyond the random publishes and all the stories that i come up with, I have a point that just clicked my mind. Now a days in offices we have people working with computers and most extensively MS Office tools, among the tools one of the most challenging tools for all is MS Excel. So thought of just sharing some tips on it... its not that i know it all but then just trying to share whatever i  know.

Starting with the very basic of the formulas:

How to add up a list of number together in one cell: 

Lets see how we can just add two or more number using a formula:

Now go to the cell where you want to get the sum of the desired set of numbers and type the formula "=sum("range")"

In the above case the range is from (A1:A4). Hence, the formula after you have entered might look like "(=sum(A1:A4)", after that just hit the enter button, and there is your result.

Lets see how it, looks like.


Quick tip: Shortcut for Summing up a list of number is : "ALT + H + U + S" (just see the magic :)

Try getting into these thing for a while and if you face any problems you can post your queries in the comment box. "Lets excel the excel"