How to make formula in cell constant


i have work book with 8 sheets with summary sheet , in summary sheet all the formulas are copied in cell to calculate calls counts, the problem i am facing is when ever there is any change in the data formula #REF numbers are getting changed ,this creating rework for me every time…is there any way i can make formula in cell constant i. e the formula should not get changed …i tried F4 but still they are getting changed.

any help will be appreciated !

Top Contributor Asked on April 15, 2017 in Excel: Forumlas.
Add Comment
1 Answer(s)



Can you share screenshot, file or link to file…?

Top Contributor Answered on April 15, 2017.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.