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.
|