Teacher's marksheet

[Anmol786]

I have a marksheet with students' names
in e3 to 36 columns total is put using sum formula
but suppose i enter a subject then i have to shift sum formula to F3 to F7 but manually
is there any way that i enter a column or row and put data in that column and sum formula is changed automatically for adding the data in that new coloumn
plz

Find sample worksheet

 

[Bob Phillips]

Goto Excel Options>Advanced and check the box marked Extend data range formats and formulas, it should then automatically add the formula.

Or just convert the data to a table (Ctrl-T), that will also carry formulas down).

 

[Anmol786]

Goto Excel Options>Advanced and check the box marked Extend data range formats and formulas, it should then automatically add the formula.

Or just convert the data to a table (Ctrl-T), that will also carry formulas down).

Plz do needful in sample file

plz