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-xp-training - Formulas
excel-xp-training - Formulas
Resolved · Low Priority · Version Standard
RE: Formulas
Hi Kim
Sorry we have not got back to you sooner hope you are well, there many ways to sum up figures all you would need to do is either type up a formula for example
in the blank cell under the figures: =b3+b4+b5+b6+b7 and press enter or you could also try any of the following
You could type the following formula as follows using the cell references that you need: =sum(b3:b7) in the blank cell where you answer needs to go, or you could clink on the blank cell the go to the AUTOSUM toolbar button which looks like this ∑ you can also do other formulas such as average, min and max by replace the word SUM with arevage which would look like this =average(b3:b7)
hope this helps
Mark East
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:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |