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: