ExcelBanter - sum using reference from other worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sum using reference from other worksheet (https://www.excelbanter.com/excel-worksheet-functions/44206-sum-using-reference-other-worksheet.html)

Pankaj

sum using reference from other worksheet

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

CLR

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

Vaya con Dios,
Chuck, CABGx3

"Pankaj" wrote:

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

All times are GMT +1. The time now is 10:51 PM.