Numbers - IF, SUMIF, COUNTIF, WHAT IF??
I have a column of dollar figures. A correlating column of multiple choice options. And a total amount to achieve.
I4:I10 - Dollar figures
J4:J10 - Multiple Choice Options
H3 = Total Dollar Amount
If any cell in range J4:J10 = "Square" or "Square 0%", then that correlating dollar figure in column I should not be tallied in H3.
Ex.
I need a formula that tallies the sum of the figures in column I EXCEPT when a cell in column J = "Square" or "Square 0%".
So, in this case, the total "Earnings" should be $209.
MacBook Pro (Retina, 13-inch,Early 2015), macOS Sierra (10.12.3)