linking across matrices

4.76K viewsFormulas and Functions

How do you link a line on one matrix to the workings on another when the workings has 2 working tablets, i.e. total, then 2 lines and a sub total in the next field, when I make one equal the total, it only brings up the top line in the next field, not the subtotal at the bottom. Is there a skip style mechanism?


Total First year
Sub total

These are the 2 category tiles, and I need a row in another matrix to equal the subtotal amount, which is the sum of several above rows above.

You are viewing 1 out of 4 answers, click here to view all answers.

Latest Questions