sumif absolute values

D

DM

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

Bob Phillips

Can you elaborate, with some example?

--

HTH

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

Dave Peterson

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