using data from one worksheet in another worksheet

[J]

I have 2 wksheets that have a cell that has a total sum of expenses for that
year at the bottom. I then have another worksheet that I'm trying to take the
totals (which are using the sum formula for that worksheet) of those
worksheets and places it on the this sheet. I have tried the formula of using
the = then clicking on the cell of the other wksheets but I get an amt of
$0.00 which isn't true. I think it's because the totals on the other
wksheets are using the sum formula. Could use any help with this. Much
appreciated.

 

[trip_to_tokyo]

Hi J.

Please refer to:-

http://www.pierrefondes.com/

In here please look at item number 47 towards the top of the page.

There are 2 EXCEL 2007 files here:-

avinity1.xlsx and

avinity2.xlsx

You seem to be doing what is right.

With reference to the above Worksheets:-

In avinity1.xlsx in cell G 22 I type the number 1

In avinity1.xlsx in cell G 23 I type the number 2

In avinity1.xlsx in cell G 24 I type =SUM(G22:G23)

This returns the value of 3 to cell G 24 (and this is correct).

Now I flip over to avinity2.xlsx.

In cell G 24 I type:-

=[avinity1.xlsx]Sheet1!$G$24

This correctly pulls in the value of 3 from G 24 in avinity1.xlsx.

Does the above help you out?

If my comments have helped please hit Yes.