HOW TO SUM UP CELLS IN SEPARATE WORKSHEETS IN EXCEL

Tim · Oct 22, 2004

I am trying to add up one cell in 3 work sheets and place the result in
another. How do I do this? I know this uses the Sum function key

Frank Kabel · Oct 22, 2004

Hi
use a formula like
=SUM('sheet1:sheet3'!A1)

JulieD · Oct 23, 2004

and if the worksheets are not adjacent to each other try
=Sheet1!A1+Sheet3!A1+Sheet5!A1
or
=SUM(Sheet1!A1,Sheet3!A1,Sheet5!A1)

Cheers
JulieD