sumif absolute values
 

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

sumif absolute values
 

Can you elaborate, with some example?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DM" wrote in message
...
Is there any way to embed an absolute value function within a sumif
function?
Is there an array formula that will do this?

sumif absolute values
 

=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