The sum of absolute values present in column AB1 to AB100.
At cell AB 101 enter command =sum(abs(ab1:ab100))
after entering the values type CTRL+SHIFT+ENTER at last. will execute the function as an array function and the function is changed as {=sum(abs(ab1:ab100))}
Another option to perform the same is
=sumproduct(abs(ab1:ab100))
No comments:
Post a Comment