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
Bookmarks