On the Data tab, in the Data Tools group, click the Consolidate button. Click in the Reference box and then click the Spring and Fall worksheets tab. Click and drag to select D5:D12. Click the Add button. Click the Spring and Fall worksheets tab. Click Add. Click the worksheet tab. Click Add. Click OK.
In details, to consolidate data from range D5:D12 in the Spring and Fall worksheets using the SUM function, follow these steps:
- Open the workbook containing the Spring and Fall worksheets.
- Switch to the worksheet where you want to display the consolidated data.
- Select the cell where you want the consolidated data to appear.
- Type the following formula into the selected cell: =SUM('Spring'!D5:D12,'Fall'!D5:D12)
- Press Enter. The SUM function will add up the values from the specified ranges in the Spring and Fall worksheets and display the result in the selected cell.