Try this array formula which cannot use the entire column and must be
entered using ctrl+shift+enter

=MAX(IF(O1:O100<0,O1:O100))-MIN(IF(O1:O100<0,O1:O100))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ayeFayze" wrote in message
...
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.