Turning the Total Row on and off for an Excel Table is easy. In a PivotTable Microsoft Excel may calculate an incorrect grand total for a calculated field. Sum All Columns In The Total Row Of An Excel Table Video Excel Excel Tutorials Microsoft Excel Tutorial The running total will now be included in the preview window. . Try out 5 different ways to total columns. Add subtotal rows in a table in Excel. From 31-Mar-2017 it returns 31 which is the total number of days in March month. This problem occurs when you use a calculated field a field that is based on other fields in a PivotTable and the calculated field is defined by performing a higher order arithmetic operation such as exponentiation multiplication or division on other fields in the. The day of the months last day is always the total number of days in a month. In the next post I explain a different use for SUBTOTAL in more of an outline or report style format.