View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom@AML Tom@AML is offline
external usenet poster
 
Posts: 1
Default 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.