save sum of 2 number after deleting them
Hi, I need help for a simple problem about Excel. Please help like always. Bless you.
I had a simple Excel file, like the attached picture, which have 2 numbers. Cell B4 calculates sum of them. I want to save the value of B4 in B6 and then delete B2, B3 and B4. So, I copy B4 in B6; but after deleting B2, B3 and B4, the value of B6 is deleting too. Is there another method, except copy/past or writing the value of B4 in B6 by hand, to save the value of B6 even deleting the values of B2, B3 and B4?
Thanks for any help.
|