Excel Formula

[Guest]

I sent a question yesterday concerning using multiple worksheets (10) to
total into one work sheet. The problem that I am having with the formula
that was given to me yesterday is that my formula always comes back invalid
(NAME). The formula that was given was =SUM(Sheet1:Sheet10!A1).

The cell range that I am trying to total is c4:C9 to total into C11. Please
let me know if I am missing something. Each worksheet has the same exact
columns and rows, the only thing that differs are the total added into the
each column. All of the worksheets are names of employees.

I am totally at a lost. Any assistance would be greatly appreciated.

Lillie

 

[kurttrail]

I sent a question yesterday concerning using multiple worksheets (10)
to total into one work sheet. The problem that I am having with the
formula that was given to me yesterday is that my formula always
comes back invalid (NAME). The formula that was given was
=SUM(Sheet1:Sheet10!A1).

The cell range that I am trying to total is c4:C9 to total into C11.
Please let me know if I am missing something. Each worksheet has the
same exact columns and rows, the only thing that differs are the
total added into the each column. All of the worksheets are names of
employees.

I am totally at a lost. Any assistance would be greatly appreciated.

Lillie

My guess would be, try asking in a group for excel, not in a group for
windows.

--
Peace!
Kurt
Self-anointed Moderator
microscum.pubic.windowsexp.gonorrhea
http://microscum.com/mscommunity
"Trustworthy Computing" is only another example of an Oxymoron!
"Produkt-Aktivierung macht frei"

 

[Guest]

Great question, I would like to know as well.
Change the A1 to C11 and see what happens.

 

[Bob I]

This isn't a Windows operating system issue but should have been asked
in the Office group at the least.

But to answer in short using the following as example

=SUM(Sheet1:Sheet10!A1)

replace "Sheet1" with the name of the leftmost or 1st sheet
replace "Sheet10" with the name of the 10th sheet or the last one of
interest and finally
replace "A1" with "C11"

 

[Gord Dibben]

LDW

You do have sheets named Sheet1 to Sheet10?

Or are they named something else?

From the #NAME error I would assume "something else".

Assuming C11 is the total cell on each sheet..........

Assuming you are bringing the data to a Summary sheet........

Have Summary sheet first in workbook.

To right of this sheet insert a new sheet and leave it blank.

Name it Start.

Insert another blank sheet at end of all sheets.

Name it End.

On Summary sheet enter this formula in a cell.

=SUM(Start:End!C11)


Gord Dibben Excel MVP

 

[Gord Dibben]

In future, would be best to post this to one of the Excel news groups.

microsoft.public.excel

microsoft.public.excel.misc

microsoft.public.excel.newusers


Gord

 

[Peter Foldes]

Not if they are using CDO to post. They would need to insert the newsgroups
below into their IE Browser's address bar to be able to access them

news://msnews.microsoft.co/microsoft.public.excel
news://msnews.microsoft.co/microsoft.public.excel.misc
news://msnews.microsoft.co/microsoft.public.excel.newusers