Code:
=((Attendance!$D$3*Attendance!D5))+ ((Attendance!$E$3*Attendance!E5))+((Attendance!$F$3*Attendance!F5))+((Attendance!$G$3*Attendance!G5))+ ((Attendance!$H$3*Attendance!H5))+((Attendance!$I$3*Attendance!I5))+((Attendance!$J$3*Attendance!J5))+ ((Attendance!$K$3*Attendance!K5))+((Attendance!$L$3*Attendance!L5))+((Attendance!$M$3*Attendance!M5))+ ((Attendance!$N$3*Attendance!N5))+((Attendance!$O$3*Attendance!O5))
I may need to extend this to other coulmns, is there a shorter method