I've got the following data:
And beneath the last visible cell on column
C, I want to sum up all values in the cells, but only if their corresponding value on column
B (the "Taxed" checkbox) is set to false.
I tried this formula:
=SUM(INDEX(QUERY(B2:C11, "WHERE B = FALSE" , 1), , 2))
But it doesn't work well. It gives me $169.30, but it should be $115.23.
Is there any way I could fix my formula, or do I need to use something else?