ExcelBanter - How to set up variable data ranges in nested functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to set up variable data ranges in nested functions (https://www.excelbanter.com/excel-worksheet-functions/149276-how-set-up-variable-data-ranges-nested-functions.html)

Tom@AML

How to set up variable data ranges in nested functions

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.

Max

How to set up variable data ranges in nested functions

SUMPRODUCT should provide one way, eg:
=SUMPRODUCT(ABS(A1:A100-B1:B100))
Adapt the ranges to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tom@AML" wrote:
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.

Tom@AML[_2_]

How to set up variable data ranges in nested functions

Max,
Thanks very much! Works great.
Tom

"Max" wrote:

SUMPRODUCT should provide one way, eg:
=SUMPRODUCT(ABS(A1:A100-B1:B100))
Adapt the ranges to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tom@AML" wrote:
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.

Max

How to set up variable data ranges in nested functions

welcome, Tom. thanks for posting back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tom@AML" wrote in message
...
Max,
Thanks very much! Works great.
Tom

All times are GMT +1. The time now is 05:26 AM.