Absolute Sumif
Hi,
you probably mean this
=SUMPRODUCT((A1:A9="a")*(ABS(B1:B9)))
or may mean this
=ABS(SUMIF(A1:A9,"a",B1:B9))
Mike
"Anthony" wrote:
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
--
Tony
|