I am trying to compose a formula that will sum positives and absolute value negatives, but only if the row they are in meets one of several criteria.

For just totaling, I use =SUMPRODUCT(SUMIF(A1:A10,F1:F3,B1:B10)) where F1:F3 lists the preset criteria. Works great.

I have tried using =SUMPRODUCT(ABS(SUMIF(A1:A5,F1:F3,B1:B5))); however, this calculates the sum of each array, then adds them as absolute values.

How do a calculate the absolute value of the array first? Am I going about this wrong?