Checkboxes in Number

Birch2041 wrote:

when checkbox B3 & C3 is 'ticked', the numerical value at B10= (B15+B16). Is this possible?

You can do something like this:

=IFS(AND(B3,C3),SUM(B15:B16))

The idea is that checkboxes are either TRUE (checked) or FALSE). You test for that with a conditional statement.

See an explanation of IFS, with examples, here. You can also look at examples under the IF function.

This is a literal reply to your question. You will need to consider what you want to happen if only one of the boxes is checked, or none are checked.

Also, highly recommend breaking up the "Excel-like" table into smaller special purpose ones. Have a look at the templates at File > New in your menu for examples of effective use of tables in Numbers.

SG

Hi Birch,

As SGIII says, in the post above, "This is a literal reply to your question. You will need to consider what you want to happen if only one of the boxes is checked, or none are checked.

Your question:

"when checkbox B3 & C3 is 'ticked', the numerical value at B10= (B15+B16). Is this possible?"

But I'm wondering if your literal question is your actual question.

According to the labels of the columns and rows:

B3 applies to a "Day" amount for "Monday"

C3 applies o a "Day" amount for "Tuesday"

But the amounts to be summed are labeled "Day" (cell B15) and "Night" (cell B16" (with the weekday no specified).

Are these the correct amounts to be summed when these two cells are checked?

Adding to the confusion, you have lines labeled:

Day

Night

with no 'day' specified.

Three days with "Night" specified, but no corresponding days with Day specified,

and one cay specified only as a Public Holiday/

Somewhat confusing, and difficult to manage.

What is the overall purpose of the table? When you are able to accurately express that purpose, you are well on the way to solve the issue of making a spreadsheet document to provide an answer.

At first sight, I'd say the initial step would be to place the rows where you are recording the data Row 15 and onward) in a table separate from the one in which you are summarizing or analyzing that data.

As you have described the calculations, and as SG has translated that description into a formula, each piece of data is in a separate cell, identified (in the description and formula) by the cell's address, rather than determined by the labels telling where that data is to be found. That works, but it means that every formula in the table requires the address of each cell containing data that it is to use—a process that can get quite tedious with a growing table.

Separating the data table from the calculations table permits providing a distinct label for each column of the separated columns, which in turn permits using formulas with references applying to full columns rather that to single cells, and permits functions (SUMIF, COUNTIF, etc.) that can take adval=ntage of that type of reference.

This will sound less like gobblety gook when we're able to provide more applicable examples. For that, though, we'll need answers to my questions above.

Regards,

Barry