my formula always messsed up while sorting in excel what should i do ??

kakashi890 Well, you can see for yourself why it doesn't work. Click in the formula in C2 after the sort. It refers to the cell above (C1) and adds 256, resulting in the error. But then, when you come to naruto knife, the value in C9 is just the number 300. C10 seems to work again as it refers to the cell above (which now has the number 300) and adds 256. But obviously, that is not the correct value.

You simply can't sort ranges that contain formulas like that. The references are relative and do not 'stick' to the original "cell above". And if you make all reference absolute, they will not 'stick' either.

Depending on what you want to achieve, consider a copy/paste values of the PRICE column before sorting. That will fix the prices with the names and the items on the same row.