I have this problem, dealing since yesterday with how to solve this thing:
I have a table with differente projects and I want to sum all the items with that category, and in another column to sum only if each row has a TRUE on its checkbox. Is like having different scenarios for the same budget.
I could sum all the items with the same project but I can’t realize how to add a “if” inside that formula, or if I have to change the formula.
Here is my formula:
And here you can see my tables:
Any ideas? I feel Filtering is a very common problem, despite the documentation and the tutorial, I always have probles with this nice formula.