One more thing.

The sheet names in formulas are case-sensitive so SHEET1 may not be correct.


Gord

On Fri, 12 Jun 2009 16:59:30 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Simply =Sheet1!G234 should suffice.............no need for SUM

Do you have a space in the sheet name like Sheet 1

Then you would need to wrap in single quotes.

='Sheet 1'!G234

To see how Excel does it..........select a cell on sheet10 and type =

then switch to sheet 1 and select G234 and hit ENTER key.


Gord


On Fri, 12 Jun 2009 16:37:01 -0700, ADC76
wrote:

OK. I think I may have figured out what I was doing wrong. All I want to do
is display whatever value is in Sheet 1 G234. I typed in =SUM(SHEET1!G234)
and got a "REF" error. I may be using the wrong function to do this. Sorry
for the confusion.
ADC7

"Don Guillett" wrote:


but it's not working out so great.
??
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ADC76" wrote in message
...
Hello,
I'm trying to make a sales tax spreadsheet for my business. I have the
spreadsheet broken up into 9 sheets -- each sheet being it's own city. On
the tenth sheet I would like to have a total of the sales tax collected
from
each city. I thought I could do this by using this formula, but it's not
working out so great.
=SUM(SHEET1:SHEET9!G234)
This is just the total for one city. I will duplicate the formula
accordingly for each city listed on Sheet 10.
Any help would be appreciated.
ADC7