You said "Those formulas don't seem to work right if there are blank
(MT) cells in the range!" What I posted corrects the behavior with blank
cells. I agree that the OP's body (inconsistent with his subject) calls
for a different treatment of negative numbers, but it was not his post
that I responded to.

Jerry

RagDyeR wrote:

<"My post resolves that."

'Fraid it *doesn't*, Jerry!

Dave's new one does though.