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.