subtotals

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals

Subtotals

resolvedResolved · 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


 

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, 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.

View all Excel hints and tips


Server loaded in 0.1 secs.