ActiveX Checkbox defining formula in another cell

[tmo]

I'm new at this, please help

I have activeX checkboxes in a column of cells that also have numeric values. I want to total the values in the cells of the column by adding cells ONLY if the checkbox in that cell is not checked. When the box is checked, I do not want the value included in the sum. How can I do this?

 

[Sal Paradise]

I suggest using checkboxes from the 'Forms' toolbar. Link them to a cell in each row.

Let's say you link the cells to column A, and you want to sum the values in column B for all values that aren't checked:
=SUMIF(A1:A100,"<>"&TRUE,B1:B100)

I'm sure you can do it with a macro too, but it will get a bit more complicated.

 

[tmo]

Thanks, Sal - it worked beautifully.