Check off Box??
 

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.

Check off Box??
 

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.
formatcellsfontscroll 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

"LisaLisa" wrote:

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.

Check off Box??
 

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)

--
Biff
Microsoft Excel MVP


"FSt1" wrote in message
...
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.
formatcellsfontscroll 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

"LisaLisa" wrote:

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.

Check off Box??
 

you right. i just learned something.

thanks
FSt1

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"FSt1" wrote in message
...
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.
formatcellsfontscroll 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

"LisaLisa" wrote:

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.