View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pls123 pls123 is offline
external usenet poster
 
Posts: 121
Default sum of absolute value of each cell of a column..

hi all !!
i try in workbook function, and i try in vbe but i can't do it by myself...

i need the sum of the absolute value of each cell in range L2:L6..
if you can do it in workbook function ,please add a INDIRECT in your
fornula, because it is a range that has occasional shift.
txx !!
paolo