Here is the problem in a nutshell:

Column 1     Column 2

58000             100%
7000                50%
7000                50%
50000              50%
50000              50%

I need a function that adds all values in column 1 that are 20000 or
higher AND are 50% in column 2, lastly I divide the result by two.  I
tried something like this:

=SUMIF(M158:M163, "50%", (L158:L163,">19999")/2

Didn't work.  The correct output using the sample numbers above is
50000.00

Thanks!