Search code examples
excelfunctioncell

Link the function from one cell to the same cell in another sheet

I am trying to link the function from one cell to the same cell in another sheet.

The idea is that each sheet has different data used in the function. But the functions used are the same and are located in the same cells, so I want to make sure that if I change one function I change them all at the same time.

I hope for either of two solutions:

  • having all the function cells linked so no matter what formula I change the others will to.

or

  • having one main sheet that lets all the following sheets inherit the main function.
Solution

  • Group the sheets before entering or changing the formulae. BTW =SUM.IF is not valid syntax.