Check off Box??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LisaLisa - 27 Oct 2007 15:56 GMT

Can I add a "check off box" into a document. I am trying to add a box that I
can click and as I go through a document. As I "click or check-off" a box,
the column will add those rows that have been checked. I know how to use the
"IF" function, but I want the user to just be able to click the box as
apposed to writing something in the box that would trigger the value in the
row to be added into the total.

Reply to this Message

FSt1 - 27 Oct 2007 18:40 GMT

hi.
if you are talking about a check box control, that wont work for formulas
cannot detect controls. but allow me to suggest.
format your "check" column to marlett.
format>cells>font>scroll to marlett
type the letter a. a check mark will appearin the cell instead of the letter
a.
then use the sumif formula. if your "check" column is column A and your sum
column is column b then the formula would look like this.
=SUMIF(A1:A6,"a",B1:B6)
ever though you are seeing a "check", excel is seeing the letter a.

my thoughts.
regards
FSt1

> Can I add a "check off box" into a document. I am trying to add a box that I
> can click and as I go through a document. As I "click or check-off" a box,
> the column will add those rows that have been checked. I know how to use the
> "IF" function, but I want the user to just be able to click the box as
> apposed to writing something in the box that would trigger the value in the
> row to be added into the total.

Reply to this Message

T. Valko - 27 Oct 2007 19:00 GMT

>if you are talking about a check box control, that wont work
>for formulas cannot detect controls.

But a formula can detect the linked cell.

=SUMIF(A1:A10,TRUE,B1:B10)

Signature

Biff
Microsoft Excel MVP

> hi.
> if you are talking about a check box control, that wont work for formulas
[quoted text clipped - 24 lines]
>> the
>> row to be added into the total.

Reply to this Message

FSt1 - 27 Oct 2007 19:41 GMT

you right. i just learned something.

thanks
FSt1

> >if you are talking about a check box control, that wont work
> >for formulas cannot detect controls.
[quoted text clipped - 31 lines]
> >> the
> >> row to be added into the total.

Reply to this Message