Maybe:-

=SUM(ABS(A1:A20))

enter with Ctrl+Shift+enter

Mike

"pcj101" wrote:

How do I change the cells in a column to absolute values then add them up in
one formula or function?