Thread
:
sum of absolute value of each cell of a column..
View Single Post
#
3
Posted to microsoft.public.excel.programming
pls123
external usenet poster
Posts: 121
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
Reply With Quote
pls123
View Public Profile
Find all posts by pls123