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