Your formula is correct in that it returns the sum of G234 across all
sheets, so if G234 is the sales tax for each sheet then you are summing all
the cities, not just one city.

Works great to get the total sales tax.

If you want to see the sales tax for one city, simply

=Sheet1!G234

=Sheet2!G234

Or =INDIRECT("Sheet" & row(1:1) & "!G234")

Copy down to row 9


Gord Dibben MS Excel MVP


On Fri, 12 Jun 2009 15:41:01 -0700, ADC76
wrote:

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