Financial data such as sales information is often separated into multiple sheets. A common separation would include one worksheet for each day of the week. It is then necessary to calculate a total of sales by individual.
In this recipe, you will learn to use the SUM formula combined with VLOOKUP formulas to gather sales information across multiple sheets.
The sales information in this recipe includes the sales of 10 individuals spread across three worksheets for sales performed on Monday, Tuesday, and Wednesday. Finally, we will calculate the total sales by individual on a Summary tab:
1. On the Summary page, click on cell D2 and enter the first part of the formula to create the SUM function and the beginning of the VLOOKUP function:
2. While still entering the formula, click on the Monday tab and select all of the cells from B2 through D11 (this is the full range of data minus the column headings). After selecting the cells...