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
MacMost Q&A Forum • View All Forum Questions • Ask a 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?
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?”
Comments Closed.
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.