Problem when deleting excel cells

Hi,

I'm having problem with excel cell.

If I do total with SUM function the total showing normal but when I delete one cell which are included in the SUM function the total didn't change at all.

I have upload the file to my GDrive.

So when I delete the number in the code 9230-1 the total which is in yellow mark didn't change.

https://drive.google.com/open?id=14uIqhvwEiaKN8ssPCmPVNJJSUiGbdl0A

We will not check a file that is uploaded to a third party site, this site is capable of having attachments made to posts!!

Your problem is that you have calculation turned on to manual, press F9 and see if the figure changes!

Simon Lloyd said:

We will not check a file that is uploaded to a third party site, this site is capable of having attachments made to posts!!

Your problem is that you have calculation turned on to manual, press F9 and see if the figure changes!

Click to expand...

Dear Simon,

I will check and thank for the suggestion. And as for uploading file I will upload it directly to the site.

Thanks again.