How to set up variable data ranges in nested functions

T

Tom@AML

Trying to set up the following computation in excel.
=Sum(abs(An - Bn)+abs(An+1 - Bn+1)+...+abs(Am - Bm))
where the row range varies from n to m.
 
M

Max

SUMPRODUCT should provide one way, eg:
=SUMPRODUCT(ABS(A1:A100-B1:B100))
Adapt the ranges to suit ..
 
T

Tom@AML

Max,
Thanks very much! Works great.
Tom

Max said:
SUMPRODUCT should provide one way, eg:
=SUMPRODUCT(ABS(A1:A100-B1:B100))
Adapt the ranges to suit ..
Click to expand...
 
Top