Is there a way to structure a conditional sum function (e.g. SUMIF) to add together the absolute values in a set of positive and negative numbers in a column. In the example below the goal is to sum only the Y absolute numbers in column B and the results should be 10.
<tbody>
</tbody>Any help on this is appreciated. Thanks!
A | B |
X | 1 |
Y | -5 |
Y | 4 |
X | -3 |
Y | 1 |