Checking formula type (reference to other worksheet or not)

[topola]

In the worksheet cells I have two types of formulas: references to
another worksheet or summing cells within this worksheet.

Is there a formula to tell those two apart?

TIA, topola

 

[DtTall]

In the worksheet cells I have two types of formulas: references to
another worksheet or summing cells within this worksheet.

Is there a formula to tell those two apart?

TIA, topola

Just look in the formula bar. If it is just a simple sum, that will
be all you see. If it is another workshet, then it will have that
worksheet name in the formula. If it is another file, it will contain
the file path.