Using Formulas in different worksheets

[lee9495]

Hello all,

I have tried to do a search for my problem saw someones reply but still couldnt get my head around it.


2 Worksheets, one (Overall Fees) showing all accounts sorted that for sum wise. Other worksheet (match fees) I have values A5-O5 that i want adding up in cell H6 on (overall Fees worksheet)

=Sheet1!$A$1+Sheet1!$B$1

The above formula was a solution i just edited it but didnt work and kept asking for update values.

=matchfees!$A$5+matchfees!$O$5

Hope you can help.

Thanks

Lee

[tuph]

2 Worksheets, one (Overall Fees) showing all accounts sorted that for sum wise. Other worksheet (match fees) I have values A5-O5 that i want adding up in cell H6 on (overall Fees worksheet)

=Sheet1!$A$1+Sheet1!$B$1

The above formula was a solution i just edited it but didnt work and kept asking for update values.

=matchfees!$A$5+matchfees!$O$5

You may have a difference in the tab name and the name you are trying to enter into the formula. Note that one has a space and the other doesn't.