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 training course - HOW DO I CREATE A FORMULA
excel training course - HOW DO I CREATE A FORMULA
Resolved · Low Priority · Version Standard
Tanis has attended:
PowerPoint Introduction course
Excel Introduction course
HOW DO I CREATE A FORMULA
Tell me more about sum functions
RE: HOW DO I CREATE A FORMULA
Hi Tanis,
Thanks for the question.
The sum function is the easiest way to total numbers up within a range. You can use the Autosum button on the toolbar or similarly you can type =sum( and then highlight the range of cells you want to add up.
If you use a comma instead of a colon you can add individual cells up. For example, =sum(A1:C1) will add up A1 plus B1 plus C1, wheras =sum(A1,B1) will only add up the two cells A1 and B1.
Is there any specific questions or problems you have? If so please do not hesitate to let me know
Tracy
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 and unhiding rows using the keyboardCTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal |