98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Linda has attended:
Word Intermediate course
Excel Introduction course
PowerPoint Introduction course
Excel
Just remind me how to get SUM again !!!
RE: Excel
Dear Linda
Thank you for attending Excel Intro Course. I hope you enjoyed the course and it was beneficial to you.
SUM is one of the many functions that Excel provides you. The purpose of functions is that it save you time and confusion when performing calculations. For example if you were to Add Ten cells then you would have to press = and then type in each cell followed by the + sign nine times.
Sum function allows to simplify things. You press = and then type Sum followed by the bracket and then simply select the cells that you intend to Add.
e.g.
=SUM(A2:A10)
Another easier method of Sum is to use the AutoSum feature.
You simply click on the cell where you want the result. Click on the AutoSum Button which is on the the standard toolbar on the right hand side. This is like a Letter E ( also known as Greek Letter Sigma).
I hope this has helped in answering your question.
Please mark this post as resolved if you are satisfied with the answer. If you need further clarification then please press the Reply button and ask for further clarification.
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding Formulae in the Formula BarIt is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar. |