Absolute Sumif

[Anthony]

Hi I am trying to do a normal 'sumif' but would like the sum to be based on
absolute values.

Any ideas greatly appreciated

Thanks

 

[Mike H]

Hi,

you probably mean this

=SUMPRODUCT((A1:A9="a")*(ABS(B1:B9)))

or may mean this

=ABS(SUMIF(A1:A9,"a",B1:B9))

Mike