Check boxes for adding up numbers

[xdj]

Howdy,
It sounds simple enough, but I can't seem to grasp the concept.
I have a column of prices, I would like to have check boxes in a column beside the prices so that I can check the boxes and that they give me the sum of the prices that are checked.
Is that possible?
Any help would be appreciated.

Cheers,

Chris

 

[Jonmo1]

Sure, make sure you're using the Checkboxes from the "Control Toolbox" Toolbar, not the "Forms" Toolbar...

once you get your checkboxes in (or while you're putting them in), right click each one, properties.
Find the Linked Cell Property. Set that to a cell adjescent to the cell with the value you want summed. For example, if you're wanting to sum A1 based on that checkbox, put B1 as the linked cell..

Once you have all those done, each cell in column B will now = TRUE or FALSE based on the checkbox being checked...

then you can use Sumif
=SUMIF(B1:B10,TRUE,A1:A10)

Hope this helps...

 

[xdj]

Thank you for the response.
I'm having problems with the check box, it's always checked. I can not uncheck it.
Any suggestions?

Thank you,

Chris

 

[Jonmo1]

Make sure to Exit Out of Design Mode.

That's a toggle button on the "Control Toolbox" Toolbar

 

[xdj]

Hey, that's it!
Now to continue on with it...
Thank you.

 

[xdj]

jonmo1,
Now all that happens is when I check the box, TRUE appears in the location where the price is and FALSE when it is unchecked.
What did I do wrong?

 

[Jonmo1]

The linked cell of each checkbox should be a cell NEXT TO the cell with the price...Not the cell with the price itself..

 

[xdj]

Sweet!
Is there a way for the "TRUE" and "FALSE" not to be displayed?
Thanks,

 

[Jonmo1]

You can HIDE that column, or set the Font Color to White...

 

[xdj]

Thank you very much for all you help!

Cheers,

X