Forum Question: How Do I Make a Checklist That When Items Are Checked They Add a Certain Numeric Value To a Totals Column At the End Of the Checklist?

I am trying to make a proposal sheet that has checkboxes for each item I am trying to propose and a totals column at the end. I would like to have it so that when a certain cell is checked it adds a numeric value into the totals box at the end. BasiCally, service x is $50 per month and I will do this service every other month for the next 12 months, I would like to be able to check each month I want to do the services and then in the totals column I want it to show me how much the services will total after 12 months.
—–
Dave Harper

Comments: One Response to “How Do I Make a Checklist That When Items Are Checked They Add a Certain Numeric Value To a Totals Column At the End Of the Checklist?”

    1/16/12 @ 4:51 pm

    See today’s episode: http://macmost.com/counting-items-in-iwork-numbers.html
    I show an example just like that. You can use the COUNTIF function to simply count the checkboxes and then multiply that by a fixed number:
    =COUNTIF(A,”=true”)*100
    Or, you could use SUMIF if the number is different each time.

Comments Closed.