Calculate Percent Diff
When we created our consolidation, we omitted the percent difference calculation on the source worksheets. The reason: Our consolidation used the SUM function to add values in the source worksheets. Adding the percentages would result in incorrect values for the consolidated percent differences. As a result, we need to recreate the percent difference formula in the consolidation worksheet and copy it to the appropriate cells.
Click the sheet tab for the Quarter 1 worksheet to activate that sheet.
Enter % Diff in cell F1 ...
Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
