O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Collecting user sales data across multiple sheets

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.

How to do it...

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required