Using Sumif On Two Columns of Data - How?
 

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!

Using Sumif On Two Columns of Data - How?
 

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!

Using Sumif On Two Columns of Data - How?
 

On May 9, 4:14*pm, Mike H wrote:
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!- Hide quoted text -

- Show quoted text -

Thanks Mike! Worked like a charm.

Using Sumif On Two Columns of Data - How?
 

Your welcome and thanks for the feedback

" wrote:

On May 9, 4:14 pm, Mike H wrote:
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!- Hide quoted text -

- Show quoted text -

Thanks Mike! Worked like a charm.