In .com, Pete_UK
spake thusly [top-posting inverted]:

Dallman Ross wrote:
I want to run SUMPRODUCT but ignore the sign [. . .]

Use the ABS( ) function in your SUMPRODUCT formula to return the
absolute (positive) value of column U.

Okay, I couldn't get it to work previously, but now I did:

=SUMPRODUCT($T$2:$T$211,ABS($U$2:$U$211))/SUMPRODUCT(ABS($U$2:$U$211))

I had to use SUMPRODUCT instead of just SUM for the divisor; then
it worked.

---------------
I have some columns with percentages and dollar figures, like so:

T U
Range as Expected
% of Low Proceeds
2.28% $(4,797.10)
2.28% $(5,362.40)
2.28% $(5,122.40)
2.28% $(4,882.40)
2.28% $(5,222.70)
---------------

Thanks, Pete!