In this summary sheet, we're summarizing cells from the tabs North, East and West. We're using an indirect formula to go to the North tab cell B7 and grab the cell A. We can now see that A, B, C, and D all being together indicating that there are no inverted lines. However, what we can do in addition is we can actually reveal the formula that occurs in the cell we're pointing to. We're going to use the indirect function and formula text and if error to do this. So first of all, I want to use the indirect function to tell me what's happening in a particular cell. I want it to go to the North tab and I add an exclamation mark, tell it to go to North tab and now I want it to look within my cell here, B32. I look at cell C11. That tells me that the number 12 results. However, that's not what I want. I want the formula that's given me the 12 via a sum function that's summing the four cells above. So I'm going to put in front of my formula here, formula text.

And it says formula text. What's my reference? It's this indirect function. If I add a second closed brackets presenter, it now gives me the formula. I want to put just one extra thing in front of it. If it's correct, I want that to come up. If it's not correct, then I just want a dash to appear. So I'm going to use if error to help me out. So if error says value as given, but if there's an error, what do I want to appear? I want there to be a dash. So quotes, dash quotes, and that's now correct. If I cut that to the right, perfect. I'll get the sum function, sum function, sum function. Now if I go to the East tab and I insert a row, things look very different. I can now see that where there should be a B there is a zero, and where there should be a formula, which should be the same as those either side, I just got a dash. Really useful, for at a quick glance, seeing where errors have occurred.