how do i work across workbooks in excel 2002?

I am trying to develop an application that requires me to sum values across
workbooks. Is this possible to do in Excel 2002 and how is it performed?

Open up the workbooks in question, type =SUM(
click window in the menu and select the first workbook and the cell(s),
type in a comma and repeat and select the next workbook


Regards,

Peo Sjoblom

"lesgold80" wrote:

> I am trying to develop an application that requires me to sum values across
> workbooks. Is this possible to do in Excel 2002 and how is it performed?