Why does =INDIRECT(sheet1!$a$100) when said cell contains =SUM(a1:a99) return a reference error? More importantly how do I make it work?
Sheet2 is a simple input output tally for my checking account for this month. Sheet1 is for next month. How do I write a function where the output value for sheet2 becomes the input value for sheet1? The two sheets in question are in fact part of the same file.