Good day,
In a sheet for tracking students and grades, assignments start at
column Y and are inserted to the right each day or as needed.
Currently, there have been 9 assignments-extending from col. Y to col.
AG.

I would like Excel to auto-update the references in formulas that are
in columns O, P, and Q:

Col O = SUMIF(Y13:AG13,"0",Y$10:AG$10) - this column is to sum the
total assignment points possible for a student.

Col P = (Y13+Z13+AA13+AB13+AC13+AD13+AE13+AF13+AG13) - this column is
to sum a student's points earned.

Col Q =(((Y13/Y$10)+(Z13/Z$10)+(AA13/AA$10)+(AB13/AB$10)+(AC13/AC$10)+
(AD13/AD$10)+(AE13/AE$10)+(AF13/AF$10)+(AG13/AG$10))*100)/
COUNT(Y13,Z13,AA13,AB13,AC13,AD13,AE13,AF13,AG13) - this calculates
the percentage of points earned.

The point value of each assignment is given in that assignment's
column in row 10 (as seen with $s in the col. O and Q formulas).

The first student is listed on row 13, and that student's scores are
typed in the assignment columns in row 13.

If a new assignment is added-next would be in col. AH-that is worth x# of points, is there a way for Excel to change the formulas to the following:

Col O = SUMIF(Y13:AH13,"0",Y$10:AH$10)

Col P = (Y13+Z13+AA13+AB13+AC13+AD13+AE13+AF13+AG13+AH13)

Col Q =(((Y13/Y$10)+(Z13/Z$10)+(AA13/AA$10)+(AB13/AB$10)+(AC13/AC$10)+
(AD13/AD$10)+(AE13/AE$10)+(AF13/AF$10)+(AG13/AG$10)+(AH13/AH$10))*100)/
COUNT(Y13,Z13,AA13,AB13,AC13,AD13,AE13,AF13,AG13,A H13)

And, do this for all the students-rows 13, 18, 23, 28-and so-on until
the end?

NOTE-there are 4 rows in between each student's name (the first
student's rows are 13 through 17, the 2nd student's rows are 18
through 22, etc.), and there is different data on each row.
Currently, the last row between each student is blank.

Thanks,
Arnold