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 » Subtotals
Subtotals
Resolved · Low Priority · Version 2007
Caroline has attended:
Excel Intermediate course
Excel Advanced course
Subtotals
What does the 9 mean in the subtotal formula?
RE: Subtotals
Hi Caroline
How are you, thanks for your question the answer is there are 11 functions that subtotals can perform which are numbered 1 to 11 and 9 is a sum function and that was the subtotal we did in the course so that why the number 9 is used
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
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:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |