You're welcome, and thanks for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Randy" wrote in message
...
"RagDyer"
-Thank You, they both work fine.

"RagDyer" wrote:

How about a couple of *non* array formulas:

=SUMIF(A1:A10,"0")-SUMIF(A1:A10,"<0")

=SUM(ABS(SUMIF(A1:A10,{"0","<0"})))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Randy" wrote in message
...
The cells in a SUM formula all include formulas that provide the cells
with
negative numbers, positive numbers and blank cells. Need to have the
respective values to be used in another formula as absolute values.
Need
to
have the negative values in the range to stay displayed as negatives and
the
blank cells in the range to stay displayed as blank. Tried using
=sum(abs(range)), which works fine if the blank cells are omitted from
the
range. If the blank cells are part of the range the result is
"#VALUE!".
Is
there something to add to resolve the error message?