Quote Originally Posted by FDibbins View Post
so you want a formula that doesnt reference cells, and you want a formula in each cell....but you want them both in the same cell?

sorry, that doesnt make any sense to me, perhaps you can try top explain in more detail what you are trying to achieve?
FDibbins,

Essentially I am trying to rename a mathematical formula within a cell. I.e. I want this formula 'SUM(A1:A5)' to be renamed to the word TOTAL. So that every time I use the word 'TOTAL' in the formula bar, it will refer to that formula.

Does that make more sense?