excel worksheet

please help me · Jul 16, 2004

i need to add two columns of numbers from two seperate sheets, but in the same file, that total on the second page.

Frank Kabel · Jul 16, 2004

Hi
maybe something like
=SUM('sheet1:sheet2'!A1:A100)

charlesg100 · Jul 16, 2004

You may even consider naming the columns
(INSERT>NAME>DEFINE). That may make it a bit easier to
reference.