From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Use formulas to calculate values across worksheets and workbooks

Use formulas to calculate values across worksheets and workbooks - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use formulas to calculate values across worksheets and workbooks

“

- [Instructor] We're looking at the California sheet in this workbook and the next sheet over is called Texas and as I click it, notice that the layout is identical. The numbers are different. Florida, same thing, New York, same thing. And eventually we might be adding more states to this model. There's also a summary sheet and we'd like to gather the information here from all four of those other states right here. In every one of these, since they have the same layout, cell B4, right here is for Beds In-store sales. New York, same way, Florida, same way and so on. So when we write a formula here, one way to do this, and a formula like this is sometimes referred to as a 3D formula, we want to show you two variations. I think it'll be pretty apparent which one is better. If you have only a few sheets, the easiest way to write a formula after typing the equal sign is click on the other sheet. In this case, California, I'll click…

Contents