Tough question moving data (may require macro?)


J

Josh Craig

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?
 
Ad

Advertisements

R

ryguy7272

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

HTH,
Ryan---
 

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

Top