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
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
Attachments
Last edited: