Hi i want to create formula something like this

=((B5*$AJ$5)+(B6*$AJ$6)+(B7*$AJ$7)+(B8*$AJ$8))

Itz working fine without any problem.

Now the my query is i want to continue to formula till 98 column some thing like this

=((B5*$AJ$5)+(B6*$AJ$6)+(B7*$AJ$7)+(B8*$AJ$8)...........+(B97*$AJ$97)+(B98*$AJ$98))

So can any one please let me know who do i create that formula. du i need to manually enter upto 98 columns orelse is there any other function which can solve my problem


Thanks in advance