Maybe

=SUMPRODUCT((A1:A5=20000)*(B1:B5=50%)*(A1:A5))/2

Mike

" wrote:

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!