there are multiple sheets with the same type of data on each.. if there are 6
classes there will be 6 sheets. If i have to input the student ID numbers
into a list for each it will take quite a bit of time.(lets say sheets 2-7
are class sheets and sheet one has the reference list)

i have a list similar to the one i posted already. i need to make a formula
that will allow me to multiple the test scores indiviually by the proper
%(which is based on the type and can be found in the list on Sheet 1) once i
get that amount i need to add the total of the 3 scores together and put them
into their own cell (in this case in the overall column) no matter how i try
i keep getting different errors. this needs to be able to carry over to all
sheets and copied down the entire column.

"D." wrote:

Hi,
What 5 sheets are you referring to??