adding totals of sheets

  • Thread starter Thread starter Kanidru
  • Start date Start date
K

Kanidru

I have a friend who has many Excel files, each containing data in fou
sheets. She wants to add the data in the sheets together, or even th
data in different files, if there's a way for her to do that. We'r
using Office XP on a Windows 2000 computer, if that makes a differenc
in getting advice. Any way we can add these together
 
Hi
if you want for example sum all values in the range A1:A10
over several sheets use a formula like
=SUM('sheet1:sheet10'!A1:A10)
 
You must log in or register to reply here.

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

calculate totals from added sheets 7
Limited Pivot Tbl Row and Column Fields 4
Getting Info from Last cell used 1
Keeping Cells linked 2
vlookup of sub totals 2
Look up and total 1
Copy formula from various sheets 2
Need to merge worksheets - Excel 2003 0

Back
Top