If you write a formula like:
Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references do, but the result doesn't!?
It used to work, but just stopped doing it a few minutes ago (after it crashed actually).
I know it will be something silly, but what just happened? How do I make it work as it should. What am I doing wrong?