Any helpful tips on how to recognize how to identify what column is throwing you off balance on a MS Excel...?

Question

that is calculating totals from different worksheets?

Answer 1

You have to search for it first
You can use MATCH with COLUMN to get the number of column like this:
=COLUMN (Match( A1, B1:K1,0))
so if you put 14 in A1 and the 14 is found in one of the cells in A1:K1, then it will bring the number of that column

Enjoy my profile, I am the VBAXLMan

Answer 2

Next time, try not to link sheets or workbooks. At least keep it to a minunum.

Excel have a hard time figuring which precedents to calculate first. You have to force calculate a number of time (iterations) before giving the correct answer.

Another way is to fill all inputs with '10', The answers have to come out in zeros. Again, resorting to this means your spreadsheet is becoming too complicated.

Answer 3

no