adding totals of sheets

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
 
F

Frank Kabel

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)
 
Top