I am familiar with the formula where =+ return where a value from sheet A is inserted in sheet B at a particular cell.
However, if I want the total of, say, D1 on sheet A, D1 on sheet B, d2 on sheet C, to be inserted on cell F3 on sheet D, what can I do?
Replies (6)
Please login or register to join the discussion.
=SheetA!D1+SheetB!D1+SheetC!D2
you can insert the "SheetA!D1" bit by clicking on the appropriate cell on sheet A
But it is cell D2 on sheet C that was to be included. So perhaps either =SheetA!D1+SheetB!D1+SheetC!D2 or =SUM(SheetA:SheetB!D1)+SheetC!D2
Even better: insert a blank sheet either side of sheet A and sheet C. Call them "Start" and "End". Then formula is =SUM(Start:End!D1).
Then you can easily add new sheets if required, without needing to re-do any formulas, as long as the new sheets are between Start and End. Likewise, if you want to see eg Sheet B + Sheet C only, you just move sheet A so that it is no longer between Start and End. Nice way of doing consolidating and sub-consolidating data.