I´m making a spreadsheet where is multiple values and I´d like to use a checkbox to activate/deactivate some cells. Is it possible in Numbers and how or should I try it in other way? The spreadsheet is going to customer and it is easiest way to choose what they want just only marking the right checkbox.
Numbers 1.0.3-OTHER, OS X Mountain Lion (10.8.2)
It is not possible to activate/deactivate interface features using other features in Numbers. You could add a single column that attempts to guide a user as to what boxes to check and flag error. You could also group selections such that previous selections "tell" the user what group to select next.
Without seeing an actual example of what you want to do it is hard to comment specifically but it sound like if there are more than a few selections the logic could become a mess quickly.
Post an example screenshot and that may get some ideas started.
The columns are item and price. So if customer want to buy that item, she only activate the checkbox. And the final price will only be the checked items. That is what I want, the easiest way.
You can use the sumif() function like:
Set the first row to be a header and the add a footer row:
to sum item prices where a checkbox is checked use the formula:
C10=SUMIF(A, TRUE, C)
I hope this helps
Thanks Wayne,
That's exactly what I wanted to know how to do in order to activate/deactivate rows, and consequently the sums of my columns. 🙂
Is it possible to use checkbox to active cell/row?
