wanting to check off items and have it add them to a total value

I

iao monster

Hello,
I would greatly appreciate any help with this issue.

I have data that is comprised of items which each have their own cost. Is
it possible to click a checkbox next to each of these items and have it tally
the total at the bottom for just the items that are checked off?

Thank you in advance!
 
A

akphidelt

Yes it is. For each check box you will have to right click on it and assign
its cell link to a cell on the screen. So each time you check and uncheck it
that cell changes value.

Then to sum up the total you would use a Sumif formula basically summing any
cost where the checkbox value is -1 or whatever the checkbox value is when
checked.
 
A

akphidelt

Alright first off there is 2 types of checkboxes. You want to go to

View->Toolbars->Forms

Do not use the control Toolbox Checkbox

On the checkbox from the Forms toolbox right click on it and go to "Format
Control"

There it will say something like "Cell Link". Click on the cell link box and
then click on the cell you want the value to show up in.

Now press ok, then go and click and unclick the checkbox, you will see a
TRUE or FALSE when you click and unclick it.

So now you can run formulas, such as if you put the cell links on the same
row as the cost that you want to add up. You can have a formula that says
something like

=Sumif(Range,TRUE,SumRange)

So every time you click a checkbox it will add the value up within that
range, and everytime you uncheck it, it will not add up that value.
 
I

iaomonster

THANK YOU SO MUCH!

akphidelt said:
Alright first off there is 2 types of checkboxes. You want to go to

View->Toolbars->Forms

Do not use the control Toolbox Checkbox

On the checkbox from the Forms toolbox right click on it and go to "Format
Control"

There it will say something like "Cell Link". Click on the cell link box and
then click on the cell you want the value to show up in.

Now press ok, then go and click and unclick the checkbox, you will see a
TRUE or FALSE when you click and unclick it.

So now you can run formulas, such as if you put the cell links on the same
row as the cost that you want to add up. You can have a formula that says
something like

=Sumif(Range,TRUE,SumRange)

So every time you click a checkbox it will add the value up within that
range, and everytime you uncheck it, it will not add up that value.
Click to expand...
 
Top