98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals
Subtotals
Resolved · Low Priority · Version 2003
Thu 25 Jun 2009, 14:11Delegate Krisztina said...
Krisztina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Subtotals
I have just tried the subtotals for sum and average together, but I have not got 4 columns on the left handside(where I can extend the details), only three. Is it possible to see only the totals for the average or only the totals for the sum using the same sheet?
Many thanks
Mon 29 Jun 2009, 13:27Trainer Amanda said...
RE: Subtotals
Hello Krisztina
Thank you for your question and welcome to the forum.
If you put in an average subtotal in addition to a sum subtotal, typically only 3 levels appear on the left hand side of the screen, not 4.
As far as I am aware, you would need to create a separate list (one with sum subtotals, one with average subtotals) to see only the total for one or the other. I don't think you can have them both on the same list and then only show one.
Kind regards
Amanda
Mon 6 Jul 2009: Automatically marked as resolved.
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:Quickly insert a functionIn Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog. |
