Formula question-if I try and add a column

Hi gang!

I'm an excel newby and I'm sure there must be an easier way of sorting the formula below out?

=SUM(+$B$5*B6/1000)+(+$C$5*C6/1000)+(+$D$5*D6/1000)+(+$E$5*E6/1000)+(+$F$5*F6/1000)+(+$G$5*G6/1000)+(+$H$5*H6/1000)+(+$I$5*I6/1000)+(+$J$5*J6/1000)+(+$K$5*K6/1000)+(+$L$5*L6/1000)+(+$M$5*M6/1000)+(+$N$5*N6/1000)+(+$O$5*O6/1000)+(+$P$5*P6/1000)+(+$Q$5*Q6/1000)+(+$R$5*R6/1000)+(+$S$5*S6/1000)+(+$T$5*T6/1000)+(+$U$5*U6/1000)+(+$V$5*V6/1000)+(+$W$5*W6/1000)+(+$X$5*X6/1000)+(+$Y$5*Y6/1000)+(+$Z$5*Z6/1000)+(+$AA$5*AA6/1000)+(+$AB$5*AB6/1000)+(+$AC$5*AC6/1000)+(+$AD$5*AD6/1000)+(+$AE$5*AE6/1000)+(+$AF$5*AF6/1000)+(+$AG$5*AG6/1000)+(+$AH$5*AH6/1000)+(+$AI$5*AI6/1000)+(+$AJ$5*AJ6/1000)+(+$AK$5*AK6/1000)+(+$AL$5*AL6/1000)+(+$AM$5*AM6/1000)+(+$AN$5*AN6/1000)+(+$AO$5*AO6/1000)+(+$AP$5*AP6/1000)+(+$AQ$5*AQ6/1000)+(+$AR$5*AR6/1000)+(+$AS$5*AS6/1000)+(+$AT$5*AT6/1000)+(+$AU$5*AU6/1000)+(+$AV$5*AV6/1000)+(+$AW$5*AW6/1000)+(+$AX$5*AX6/1000)+(+$AY$5*AY6/1000)+(+$AZ$5*AZ6/1000)+(+$BA$5*BA6/1000)+(+$BB$5*BB6/1000)+(+$BC$5*BC6/1000)+(+$BD$5*BD6/1000)

Problem is that if I try and add a column - e.g. +(+$BE$% ... then I get an error message telling me the formula is too long.

Thanks for any help.

Brilliant stuff. I do feel very foolish and appreciate the help.

No problem. Thanks for the feedback