Summing across several worksheets

G

Guest

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
 
G

Guest

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.
 
G

Guest

So obvious really....thanks!!

ewan7279 said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill across multiple worksheets 3
Totaling Cells in Worksheets 7
Summarise data from several worksheets in a workbook 2
copying & incrementing formulae across open worksheets 4
Calculating Cells across worksheets?? 3
Summary Sheet Totals 7
Charting cells across worksheets? 1
Summing up various Worksheets to one Summary sheet using variables 1

Top