Excel 2013: The Missing Manual

Errata for Excel 2013: The Missing Manual

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date Submitted Date Corrected
Printed, PDF, ePub, Mobi, Safari Books Online, Other Digital Version
Page p640-643
entire section

The book fails to note an important limitation in Excel's Grand Totals feature, which doesn't work properly with calculated fields. In this example, Excel actually calculates Sum(UnitPrice)*Sum(Quantity), when the calculation it *should* be performing is Sum(UnitPrice*Quantity). There is no simple Pivot Table or calculated field setting that can change this behavior. Instead, the most common and reliable option is to add the calculated field to the table of source data, and then use that field to make row and column totals. If you are taking your data from a worksheet table, adding this calculated field is easy enough; if you are taking it from a database, you'll need to modify your query so that it generates the calculated column. Another, different option is to use the calculation options in Power Pivot.

Matthew MacDonald
Matthew MacDonald
Dec 21, 2014