Numbers-SUMIF Question: How to use checked checkbox as condition? Scenario: Col. A checkboxes; Col. B $; When complete, I check the checkbox. Outcome=Total $ minus $ of items once checked. See attached print screen
[Edited by Moderator]
Checked boxes return TRUE() or FALSE() depending on whether they're checked or not. You can also compare them to the values 1 (TRUE) or 0 (False).
In this case, you want a sum of the values in C where A is FALSE. That would look like:
=SUMIF(A,FALSE,C)
which can be read as look at the values in column A, for every one that matches the condition FALSE, add the corresponding value from column C
(adjusted for column references vs. header labels - your use of A/B/C/D for the column headers for columns B, C, D and E is a little confusing, but I get that you're just obfuscating the data)
Worked perfectly! Thank you
How do I use a checked checkbox as a condition in Numbers app?
