ExcelBanter - Absolute Sumif

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Absolute Sumif (https://www.excelbanter.com/excel-worksheet-functions/226209-absolute-sumif.html)

Anthony

Absolute Sumif

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

Mike H

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

All times are GMT +1. The time now is 07:24 PM.