referring to other sheets in a workbook

Occasional Visitor

How can I create a link to a SUM of formula on a subsequent sheet

1 Reply

Hi @KJONES1110 

 

use the sheet name before the cells name and add ! after the sheet name,
=SUM(Sheet1!A1:A4)

 

 

* If my post helped you, please click on like.