Sum whole Row

Is there  a simpler way to achieve 

=((Attendance!$C$3*Attendance!C5))+ ((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))

I  want to use more rows in calcuation, but for illustration, it is stopped there

By: Jim

Leave a Reply

Your email address will not be published. Required fields are marked *