sum using reference from other worksheet

Pankaj · Sep 7, 2005

I wanted to sum certain cell using a reference from other worksheet.

CLR · Sep 7, 2005

=SUM(A1,Sheet2!A1,Sheet3!A1)

Vaya con Dios,
Chuck, CABGx3