=MAX(IF(A1:A1000<0,A1:A1000))-MIN(IF(A1:A1000<0,A1:A1000))

this is an array formula and must be entered with CNTRL-SHFT-ENTER
rather then just
ENTER
--
Gary''s Student - gsnu200766


"ayeFayze" wrote:

Have a column with many numbers, need difference between low value and high
value, while ignoring zeros...can this be done? thx.
--
Just because you can, doesn't mean you should.