Using Sumif On Two Columns of Data - How?

  • Thread starter Thread starter f252863
  • Start date Start date
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF Multiple Criteria in different ranges. 13
Sum data in a column if multi creteria met 3
COUNTIF/SUMIF comparing two rows of data 3
Comparing data in two sheets with similar values 4
SUMIF using two columns in both Range and Criteria 5
summing two columns of different data 4
Sorting two columns of data 6
SUMIF to sum multiple columns of data? 2

Back
Top