sum of absolute value of each cell of a column..

P

pls123

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
 
D

Don Guillett

Is this what you want
=SUMPRODUCT((ABS(B3:B9)))

where e8 has b3:b9
=SUMPRODUCT((ABS(INDIRECT(E8))))
 
P

pls123

tx don i found it..
=SUMPRODUCT(ABS(INDIRECT("A1:A9")))

sumproduct was what i missed !!!
good holiday !!
 
R

Rick Rothstein

Why are you using the Volatile INDIRECT function in that formula? This
formula will do the same thing...

=SUMPRODUCT(ABS(A1:A9))
 
P

pls123

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 !!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell values to an array, then array transpose to another workbook 8
Cell data entering slow! 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
Using the INDIRECT function across multiple worksheets 0
Absolute value 2
Statusbar cell values? 5
Insert columns and values programmatically with IF statement 9
Conditional Formatting with VBA 4

Top