How to set up variable data ranges in nested functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
SUMPRODUCT should provide one way, eg:
=SUMPRODUCT(ABS(A1:A100-B1:B100))
Adapt the ranges to suit ..
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use VBA variable in COUNTIF function? 10
SUMPRODUCT that contains multiple criteria 3
Showing the function in the active cell 5
Delta E(cmc) formula 10
Formula nesting with IF statements 2
rank the numbers / range of data using 'RANK' and 'ABS' 1
Subtotal of Abs of a range? 3
Indirect function – relative column copy/paste 1

Back
Top