Q: SUMIF of absolute values I have a spreadsheet with values like that:
A          | B
10,55 €    | x
10,05 €    | 
-0,55 €    | x
7,55 €     | 
-88,50 €   | x

I want the absolute sum of all rows with x in B
I can get the sum of x rows with =SUMIF(B2:B100; "x"; A2:A100)
And the absolute sum of all A column with =SUMPRODUCT(ABS(A2:A100))
But I don't know how to mix those 2 formulas

A: =SUMPRODUCT(IF(B2:B100="x",ABS(A2:A100)))


A: you can use an ArrayFormula in Google docs :
=ArrayFormula(SUM(IF(B2:B100="x",ABS(A2:A100),0)))

