I have a set of about 35 worksheets. I need to add up the total in all cells
that are the same. I mean D38 from all the worksheets, onto one primay
"TOTAL" worksheet. Is there someway to do this easily without having to
click plus sign and then the cell in each sheet???

Thanks. If you need further clarification let me know. The sooner I can
get the answer the better.

=SUM(first:last!D38)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"TJ7933" wrote in message
...
I have a set of about 35 worksheets. I need to add up the total in all
cells
that are the same. I mean D38 from all the worksheets, onto one primay
"TOTAL" worksheet. Is there someway to do this easily without having to
click plus sign and then the cell in each sheet???

Thanks. If you need further clarification let me know. The sooner I can
get the answer the better.

Hi TJ7933

Try =sum(Sheet1:Sheet35!D38)

where Sheet1 and Sheet35 are the names of first and last worksheets in the
range.

Regards
Phil

"TJ7933" wrote:

I have a set of about 35 worksheets. I need to add up the total in all cells
that are the same. I mean D38 from all the worksheets, onto one primay
"TOTAL" worksheet. Is there someway to do this easily without having to
click plus sign and then the cell in each sheet???

Thanks. If you need further clarification let me know. The sooner I can
get the answer the better.