Sumif Help Please
 

Hoping someone can help me out here.

I am using the following formula to calculate a recovery % in manufacturing, but the issue that I'm having is that this formula is only valid if the value in row 5 is greater than the value in row 2. Otherwise, I need to calculate the reverse, which would be row 2 value minus row 5 value.

=IFERROR((SUM(SUM((D5-D2)*D4)+SUM(D19*D20))/D21),"")

I basically want it to say that if D5 is greater than D2, then do the formula above, but if D5 is less than D2, I want the those cells to be swapped.

Sumif Help Please
 

... the following formula ... is only valid if the value in
row 5 is greater than the value in row 2.
Otherwise, I need to calculate the reverse

Maybe something like this would help:
=IFERROR((ABS(D5-D2)*D4 + D19*D20)/D21, "")