| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum of absolute value of each cell of a column..
Is this what you want
=SUMPRODUCT((ABS(B3:B9))) where e8 has b3:b9 =SUMPRODUCT((ABS(INDIRECT(E8)))) -- Don Guillett Microsoft MVP Excel SalesAid Software "pls123" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum of absolute value of each cell of a column..
tx don i found it..
=SUMPRODUCT(ABS(INDIRECT("A1:A9"))) sumproduct was what i missed !!! good holiday !! "Don Guillett" wrote: Is this what you want =SUMPRODUCT((ABS(B3:B9))) where e8 has b3:b9 =SUMPRODUCT((ABS(INDIRECT(E8)))) -- Don Guillett Microsoft MVP Excel SalesAid Software "pls123" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum of absolute value of each cell of a column..
Why are you using the Volatile INDIRECT function in that formula? This
formula will do the same thing... =SUMPRODUCT(ABS(A1:A9)) -- Rick (MVP - Excel) "pls123" wrote in message ... tx don i found it.. =SUMPRODUCT(ABS(INDIRECT("A1:A9"))) sumproduct was what i missed !!! good holiday !! "Don Guillett" wrote: Is this what you want =SUMPRODUCT((ABS(B3:B9))) where e8 has b3:b9 =SUMPRODUCT((ABS(INDIRECT(E8)))) -- Don Guillett Microsoft MVP Excel SalesAid Software "pls123" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum of absolute value of each cell of a column..
hi rick !!
the indicated range has cells that are subject to a insert shift xldown in the vbe.. so i need to use INDIRECT for avoiding the references to switch.. i did not try for SUMPRODUCT but i think it works the same way.. by !! "Rick Rothstein" wrote: Why are you using the Volatile INDIRECT function in that formula? This formula will do the same thing... =SUMPRODUCT(ABS(A1:A9)) -- Rick (MVP - Excel) "pls123" wrote in message ... tx don i found it.. =SUMPRODUCT(ABS(INDIRECT("A1:A9"))) sumproduct was what i missed !!! good holiday !! "Don Guillett" wrote: Is this what you want =SUMPRODUCT((ABS(B3:B9))) where e8 has b3:b9 =SUMPRODUCT((ABS(INDIRECT(E8)))) -- Don Guillett Microsoft MVP Excel SalesAid Software "pls123" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
| When I make a row absolute, but column relative, the column stays. | Excel Discussion (Misc queries) | |||
| CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. | Excel Worksheet Functions | |||
| How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming | |||
| How can I do an Absolute Cell Reference but non Absolute Cell Pais | Excel Programming | |||
Linear Mode
