Using Sumif On Two Columns of Data - How?

F

f252863

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!
 
Top