In Numbers, how can I make a cell reference a constant in a formula?
This is a basic question, but I am not sure of the answer. I am trying to calculate a previous SUM that I have by a column. But when I calculate it, it keeps looking for data in the cells after the SUM that I already have.
In other words, how can I get a constant cells value into my equation?
Any help would be great!
(In excel, I could do it just by placing $ around my cell field. Like H23 would be $H23$. THanks!)
Numbers works exactly like Excel in this regard. To change H23 from a reference that will change if the formula is moved to a fixed cell reference, make it $H$23.
This thread has been closed by the system or the community team.
You may vote for any posts you find helpful, or search the Community for additional answers.
In Numbers, how can I make a cell reference a constant in a formula?
Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.