Formula which add 50 every time a checkbox is checked. how ?

Question

simbiosi2018 Author

Level 1

8 points

Formula which add 50 every time a checkbox is checked. how ?

Hi Guys

I'm not an expert of NUMBERS

I need to create a simple SUM formula that add an amount ( in this case 50 ) to a TOTAL ( dedicated cell ) every time a checkbox is checked

So basically .. every time I check a checkbox in a row ... 50 it's been added to the total

I need to check the presences of my collaborators and in the TOTAL cell is the amount of what they will get.

Someone can help me ?

thanks in advance

iMac (Retina 5K, 27-inch, Late 2014), iOS 11.4

Posted on Jun 13, 2018 4:22 AM

Reply

Answer 1

Best reply

Yellowbox

Level 7

20,383 points

Jun 13, 2018 6:42 AM in response to simbiosi2018

Hi simbiosi,

Instead of placing your formula on the right, use the power of Header Columns (on the left) that will refer to a whole row.

Formula in A2 of the 'TOTAL' table =COUNTIF(Presence::2:2,TRUE)×A$1

That allows you to add more Meetings to the 'Presence' table because the formula will automatically expand to include them.

Also, you can change A1 in the 'TOTAL' table from 50 to another value without editing the formula.

Regards,

Ian.

Reply

Answer 2

simbiosi2018 Author

Level 1

8 points

Jun 13, 2018 5:18 AM in response to Wayne Contello

I cannot understand sorry ... I'm really a beginner in Numbers.

I attached a pics ...

let's say the green row

I want that everytime a checkbox is checked at the end of the green row ( on the right ) appear the total

every checkbox is 50 ( or a value that I can change )

Reply

Answer 3

simbiosi2018 Author

Level 1

8 points

Jun 13, 2018 8:18 AM in response to Yellowbox

Another Question :

What if I have this situation : I want on the right cell ( where now is written 0 ) that appear the for ex 20% total amount relative to the TOTAL SUB. ( in this ex 2000 Chf ) always controlled by the Checkboxes.

So basically the Checkbox tell me the presence and take the 20% : 8 of the TOTAL SUB. In the end on the right cell for ex Dorothee I get the total amount of it.

I don't know if I explained me well.

Basically instead of having a fix rate ( in this case was 50 ... which is the amount per presence ) I want to have a rate of 20% per presence

Reply

Answer 4

Yellowbox

Level 7

20,383 points

Jun 14, 2018 4:42 AM in response to simbiosi2018

Hi simbiosi,

Thanks for the screen shot. It will help me and other users if you delete blank rows (to make a smaller screen shot) and include the row and column labels and their headings.

Perhaps a separate summary table will help you.

Something like this? (I am guessing).

Please tell us the column Headings in row 1 of the 'Data' table.

Please tell us what the Checkboxes do.

Please tell us what you want in the 'Summary' table.

What is your overall aim?

Regards,

Ian.

Reply

Answer 5

Jun 13, 2018 4:40 AM in response to simbiosi2018

assuming the cells in column E have a checkbox...

in the cell where the TOTAL keep the existing formula (assuming it works) and append the following:

+COUNTIF(E,TRUE)*50

so if the cell with the total had something like:

=sum(D)

you would change it to

=sum(D)+COUNTIF(E,TRUE)*50

Reply

Answer 6

simbiosi2018 Author

Level 1

8 points

Jun 13, 2018 7:23 AM in response to Yellowbox

Thank you very much ... it worked exactly how I wanted 🙂

Reply

Formula which add 50 every time a checkbox is checked. how ?

Similar questions