=sumif(a1:a10,"x",b1:b10)
could be rewritten as:
=sumproduct(--(a1:a10="x"),abs(b1:b10))


DM wrote:

Is there any way to embed an absolute value function within a sumif function?
Is there an array formula that will do this?

--

Dave Peterson