In your main sheet you would have a formula like this:

=Sheet7!F20

Hope this helps.

Pete

On Mar 8, 4:58*pm, dilbert16588
wrote:
First off I am using Excel 2003

I have a workbook set up to cover my financial assets. My first worksheet
(Sheet1) is the main one which has all my data on it. The other worksheets
are where I have the detailed information to get certain figures - for
example, Sheet7. On these worksheets, I have a cell (cell F20) with a
function to add up all figures in a column for a total. I want to refer to
this formula in the cell on Sheet7 in my main worksheet (Sheet1) with all my
totals. However, I can't figure it out to get this to work. I want to be able
to add more data to Sheet7, thus changing the total in cell F20 - and this
change is automatically reflected when I switch back to Sheet1. Is this
possible? if so, how do I create the function? Thanks for your help!