MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How To Add Up Values In 1 Column That Are Greater Than Values In Another Column?

In Numbers, I have two columns with values:

col1, col2,
$200, $100
$300, $400
$500, $600

I want to add up all of the values in column 2 that are greater than their corresponding value in column 1. For the first row, I would ignore $100 because $100 is less than $200. For the second and third row, I would add up $400 and $600 because both $400 and $600 are greater than their corresponding values in column 1, $300 and $500 respectively.

How do I do this? I’ve tried SUM, SUM and IF together, and SUMIF.

I am trying to calculate how much of my poker winnings are taxable. If you walk into a casino with $100 and walk out with $200, you pay taxes on $200. So I’m trying to add up all of my sessions where I walked out of the casino with more money than when I walked into the casino.
—–
Glen

Comments: One Response to “How To Add Up Values In 1 Column That Are Greater Than Values In Another Column?”

    2 years ago

    Create a third column. Lets say your two values are in columns B and C and this new column is D.
    So in D2, put =IF(C2>B2,C2,0)
    This will test C2 to see if it is greater than B2. If it is, it puts C2 into D2. If it isn't, then 0 is put into D2.
    Now use a simple SUM in the footer row to get =SUM(D) to add up all of row D.

Comments Closed.