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 » training microsoft excel - Sum
training microsoft excel - Sum
Resolved · Low Priority · Version Standard
Joanne has attended:
Excel Introduction course
Sum
how do i sub total entries as i fill in spreadsheets
RE: Sum
Hi Joanne
Thanks for your question.
If you enter a formula where you want the total to appear, that adds the cells you are entering the numbers into, then the total will change as the numbers are entered into the spreadsheet.
Example: if the formula is entered into cell A15 as =sum(A1:A14), the total of the numbers entered into cells A1 to A14 will appear in cell A15.
Amanda
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:Cycling through Absoulte cell referencesIf you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key. |