What does this formula do? =Sum(Sheet1:Sheet4!D18)
=Sum(Sheet1:Sheet4!D18)
It adds data from cell A1 of Sheet1 and cell D18 of sheet4
It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3 and Sheet4
It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4
It adds data from cell D18 of Sheet1 and cell D18 of Sheet4