Adding Cells across Worksheets

T

TJ7933

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

Bob Phillips

=SUM(first:last!D38)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
P

Philip J Smith

Hi TJ7933

Try =sum(Sheet1:Sheet35!D38)

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

Regards
Phil
 
Top