2

I can add true/false buttons ok. I wish to have these buttons equal a number when it's ticked then be added to a total.

I'm brand new to numbers but finding my way ok so far. I do team sheets. Each member pays £2 I wish to just use a tick box to confirm they have paid then total what the true buttons.

Can it be done?

Improve this question
0

1 Answer 1

Reset to default
4

To calculate the sum of the checkboxes, where checked is 1 and unchecked is 0, use:

=COUNTIF(A, true)

Replace A with the range of cells where the checkboxes are.

You can combine this with ×2 to multiply the answer by 2, then format as currency.

Improve this answer
5
  • I am almost getting there. do I have to the formula again for rack checkbox?
    – TheBeat Apprentice
    Jun 14, 2017 at 21:46
  • @The I'm don't understand your question, the formula is input once into the cell. What's a ‘rack checkbox’?
    – grg ♦
    Jun 14, 2017 at 21:48
  • Yes I'm sorry. I should have checked text correctly. I can type first line of formula and It works. True checkbox = 2. I am now trying to repeat for all checkboxes. So trying to work that out just now.
    – TheBeat Apprentice
    Jun 14, 2017 at 22:14
  • @The Why are you repeating the formula for each checkbox? The first parameter to countif takes a range of checkboxes and sums the checked cells.
    – grg ♦
    Jun 14, 2017 at 22:15
  • Ok! New day! New learning. Thankyou firstly for your help. I Have managed now. Thankyou again👍🏻
    – TheBeat Apprentice
    Jun 15, 2017 at 7:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .