when using check box dont want excel calculate values.
 

I have three columns of data that each have a sum at the bottom. (Tehy sum
vertically) I want to add a check box to the right of the last column and if
I select to check off the box. I dont want the data in that entire row to be
calculated as part of the three different sums for the all three columns. I
do have hundreds of rows that are displayed in those three columns. How do I
make this work ?

when using check box dont want excel calculate values.
 

Instead of using a checkbox, I'd use a cell that helds what looks like a check
mark.

Format the cell using a wingdings font
And give it a format|Cells|Number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252
It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings.

Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
mark.

Say this cell is X99.

Then you could change your formula to something like:

=sum(a1:a98)+(a99*($x$99<""))

=========
You could actually add a checkbox from the Forms toolbar and assign the linked
cell to that same X99 cell.

Then the formula becomes:
=sum(a1:a98)+(a99*($x$99=true))




Markos wrote:

I have three columns of data that each have a sum at the bottom. (Tehy sum
vertically) I want to add a check box to the right of the last column and if
I select to check off the box. I dont want the data in that entire row to be
calculated as part of the three different sums for the all three columns. I
do have hundreds of rows that are displayed in those three columns. How do I
make this work ?

--

Dave Peterson