![]() Insert your subtotals as normal in the column. The second way is to use the familiar AutoSum feature of Excel, accessible in the Editing group on the Home tab of the ribbon. ![]() This works because the addition of the subtotals simply doubles the real value of the column. For instance, if you want to get a total for the range F10:F32, and there are subtotals interspersed in the column, you would use this formula for your total: Then, when it comes time to place your totals, simply use a modified SUM formula. The first approach is to place your various subtotals, as desired. In these instances, there are three different approaches you can use. The easiest solution would be to put subtotals and totals in different columns (like accountants often do), but this is not always practical for the data at hand. There are many times you may need to have both subtotals and totals in the same column of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |