Thread: How to set up variable data ranges in nested functions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom@AML[_2_] Tom@AML[_2_] is offline
external usenet poster
  
Posts: 1
Default 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.
Reply With QuoteReply With Quote