You could use 'Named Range' to add them.
Select the F9 c ell in the 1st sheet and selectInsertNameDefine
Call it F9Sheet1
Do the same for all sheets, changing only the Sheet 1 to 2 etc.
On the Total WorkSheet, enter the Formula as'=F9Sheet1+F9Sheet2+F9Sheet3'


Corey....


"mrsjoan" wrote in message
...
I have 4 worksheets in one book. Worksheet names are July, August,
September, Total. In cell F9 of each worksheet I have a dollar value I
would
like to add and place in a cell in a 4th worksheet.
Example: July's F9 is $600; August's F9 is $200; September's F9 is $100.
Now I want $900 to show in F9 of the worksheet Total.

How do I do this. I am a novice so please break it down clearly. Your
help
will be greatly appreciated