Check off Box??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
if you are talking about a check box control, that wont work
for formulas cannot detect controls.
Click to expand...

But a formula can detect the linked cell.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and move check box (check boxes) with new cell link? 1
Check Boxes 1
check box 2
when using check box dont want excel calculate values. 1
Automatically move text from one document to another 1
Use of Check Boxes 1
Tracking Check Boxes 1
Sum of check boxes that have been checked 2

Back
Top