Could somebody help me create a custom function that returns the following: A*SUM(A1:AN)+B*SUM(B1:BN)+C*SUM(C1:CN)+....+M*SUM(M1:MN) The variables would be A, A1, and MN. Many thanks!
A A1 A2 A3 ......AN
B B1 B2 B3 ......BN
C C1 C2 C3 ......CN
. . . . .
. . . . .
. . . . .
M M1 M2 M3 ......MN
A A1 A2 A3 ......AN
B B1 B2 B3 ......BN
C C1 C2 C3 ......CN
. . . . .
. . . . .
. . . . .
M M1 M2 M3 ......MN