I have a table with cleared column, what I'm trying to do is If I checked the checkbox I want that amount to be added on the other table, for context this is what I'm trying to do.
I tried
but it only shows the word TRUE or FALSE if I clicked on the checkbox , it won't show me the value
Can anyone help me?
Thank you so much
You can use SUMIF, something like this:
=SUMIF(Table 2::A,TRUE,Table 2::B)
Replace , with ; in the formula if your region uses , as the decimal separator.
For a working example see the 'Checklist Total' template at File > New in the menu.
SG
You can use SUMIF, something like this:
=SUMIF(Table 2::A,TRUE,Table 2::B)
Replace , with ; in the formula if your region uses , as the decimal separator.
For a working example see the 'Checklist Total' template at File > New in the menu.
SG
NUMBERS, Trying to incorporate the checkbox value in different table
