Is it possible to reference an excel cell in a comment?

Solution 1:

I would say: not without VBA, except for using Named-Cells, like Jüri suggested.

As far as I know, comments are not designed to be interpreted like that. This would be quite an additional feature, so I bet MS would have told you about it in their help.

However, you can do some workarounds, like using Named ranges, or editing your comment through VBA - see here: https://stackoverflow.com/questions/12567167/excel-how-to-return-comment-as-a-cell-from-a-conditional/12567739#12567739

Another workaround might be, to use comments inside your formula, like this:

=SUM(A:A)+N("Summed up my values according to" & J12)

J12 would be changed to J11 or K12, when cells are removed or inserted.