This question comes up every once in a while.
=SUM(Sheet1:Sheet3!C1:C45)

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Josh Craig" wrote:

I have data in columns and rows in different sheets.

Each sheet is the name of a company and contains data about the company.

I need a summary sheet.

What I want in the summary sheet is:
column A: Sheet Name
column B: sum(c41,c49) from each sheet
column C: sum(d41,d49) from each sheet
column D: sum(e41,e49) from each sheet
and so on...

Any ideas how I would accomplish this?