In Numbers, I have two columns with values:
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.