| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ABS
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? |
Threaded Mode
