From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Returning references with the INDIRECT function

Returning references with the INDIRECT function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Returning references with the INDIRECT function

- [Voiceover] The Excel function called Indirect is very unusual. And if you encounter it by way of the formulas tab, suppose you're looking at Look Up and Reference functions, the description doesn't quite tell us how we might use this. Returns the reference specified by a text string. In this worksheet called Indirect, it's actually tabulating data from four different sheets. The primary purpose of this worksheet is to gather data by way of a function like this, a sum function, a 3D type function. It's adding up data from four separate sheets. Now what's not being done here though is a total being calculated or shown from each of the sheets. If we want a total for the East sheet here, I can type equal. I'll click on the East sheet down below and go to cell G6 and click it and press enter. And I could certainly do the others in short order. But what if this list is much larger? Maybe it covers 10 regions, 20 regions. Maybe it's all states. Maybe it's multi-country. We'd like to be…

Contents