My workbook contains several worksheets, say 20, each relating to the hours
of a specific department within my company. I want to total the hours across
all worksheets, i.e. sheet!D,cell D34 + sheet!E, cell D34 + sheet!F, cell
D34........etc. (There may be up to 400 such mini-totals that I need in my
"totals" worksheet.)

Anyone have any good ideas how to do this other than simply adding the
cells...is there a function/macro that'll do this?

Allan

=sheetD:sheetF!D34

HTH
--
AP

"Al" a écrit dans le message de
...
My workbook contains several worksheets, say 20, each relating to the
hours
of a specific department within my company. I want to total the hours
across
all worksheets, i.e. sheet!D,cell D34 + sheet!E, cell D34 + sheet!F, cell
D34........etc. (There may be up to 400 such mini-totals that I need in my
"totals" worksheet.)

Anyone have any good ideas how to do this other than simply adding the
cells...is there a function/macro that'll do this?

Allan

Hi Al,

You enter the formula =SUM('first sheet name:last sheet name'!A1) to get the
sum of all sheets in between the first and last in your workbook.

Ewan.

"Al" wrote:

My workbook contains several worksheets, say 20, each relating to the hours
of a specific department within my company. I want to total the hours across
all worksheets, i.e. sheet!D,cell D34 + sheet!E, cell D34 + sheet!F, cell
D34........etc. (There may be up to 400 such mini-totals that I need in my
"totals" worksheet.)

Anyone have any good ideas how to do this other than simply adding the
cells...is there a function/macro that'll do this?

Allan

http://www.excelforum.com/showthread...=adding+sheets
Check this out it may help you


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523035

So obvious really....thanks!!

"ewan7279" wrote:

Hi Al,

You enter the formula =SUM('first sheet name:last sheet name'!A1) to get the
sum of all sheets in between the first and last in your workbook.

Ewan.

"Al" wrote:

My workbook contains several worksheets, say 20, each relating to the hours
of a specific department within my company. I want to total the hours across
all worksheets, i.e. sheet!D,cell D34 + sheet!E, cell D34 + sheet!F, cell
D34........etc. (There may be up to 400 such mini-totals that I need in my
"totals" worksheet.)

Anyone have any good ideas how to do this other than simply adding the
cells...is there a function/macro that'll do this?

Allan

So obvious really! Thanks!!

"Ardus Petus" wrote:

=sheetD:sheetF!D34

HTH
--
AP

"Al" a écrit dans le message de
...
My workbook contains several worksheets, say 20, each relating to the
hours
of a specific department within my company. I want to total the hours
across
all worksheets, i.e. sheet!D,cell D34 + sheet!E, cell D34 + sheet!F, cell
D34........etc. (There may be up to 400 such mini-totals that I need in my
"totals" worksheet.)

Anyone have any good ideas how to do this other than simply adding the
cells...is there a function/macro that'll do this?

Allan