Can cells be added to a calculation with true or false buttom
In this table the cells with true (by activating the hook) shall be added in the totall calculation, only.
I was trying with the IF function but have not experience with this. 😕 When I deactivate the hook the item should be removed automaticly from the adding.
Is that possible?
Would somebody help me please?
true | shoes | 23,00 € | 3 | 69,00 € |
false | trousers | 20€ | 5 | 100€ |
true | jacket | 15€ | 7 | 105€ |
total | 174€ |
Regards limmy 🙂
Numbers V3.0-OTHER, OS X Mavericks (10.9)