Excel sum of multiple column

[makdu]

=((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

 

[Legacy 143009]

=((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

That's what SUMPRODUCT() function exactly does:

=SUMPRODUCT((D3:O3),(D5:O5))

Have a nice day

 

[makdu]

Thank you.. It worked