Hi, I am very often using formula that sum the absolute values from cells in row or cells in column {=+SUM(ABS(A1:A6))}. I am using the formula in all different workbooks and sheets for different selections (so it is not always A1:A6). I do not want to type (or copy paste) the formula again and again. Is there a code that will insert this formula into a cell just below the selection (if selected cells in column) or just next to selection (if selected cells in row).
Thanks.