Share this content
2
596

excel help

what is the formula

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

Please login or register to join the discussion.

11th Oct 2017 10:26

Come again?

Do you own a mouse?

Thanks (0)
avatar
By GW
11th Oct 2017 10:59

=SheetA!D1+SheetB!D1+SheetC!D2
you can insert the "SheetA!D1" bit by clicking on the appropriate cell on sheet A

Thanks (2)
avatar
By Grundy
11th Oct 2017 11:52

=SUM(SheetA:SheetC!D1)

Thanks (4)
avatar
to Grundy
13th Oct 2017 17:39

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

Thanks (0)
avatar
to Grundy
13th Oct 2017 18:06

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.

Thanks (0)
avatar
13th Oct 2017 16:56

Use a function called "Indirect"

Thanks (0)
Share this content