Absolute values

BJC · Apr 10, 2004

Is there anyway i can sum 20 columns horizontally for the absolute number in
each column?

Leo Heuser · Apr 10, 2004

One way:

=SUMPRODUCT(ABS(A8:T8))

Frank Kabel · Apr 10, 2004

Hi
you may use the following array formula (entered with
CTRL+SHIFT+ENTER):
=SUM(ABS(A1:T1))