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