How to do the total which is not in the formula range

[Arup Dutta Chowdhury]

I have got a sample file where there is total of all the numbers is given. The formula selection range is C4:C9. Now my question is that if add numbers is column number C1,C2,C3 then the total is not getting changed. Is there any formula which will change the Total if I add numbers in column number C1,C2,C3.

 

[Ashhu]

Total is not getting changed becasue the formula range is from C4 till C9. If you change to C1:C9 it will. i.e =SUM(C1:C9).

I am not sure whether i answered.

 

[Khalid NGO]

Hi,

Your sum range is C4 to C9, You just need extend the sum range to C1 to C9:
=SUM(C1:C9)

Regards,

Edit: Ashwin beat me to it

 

[Hui]

Why not just use: =SUM(C1:C9)