counting checkmarks in excel 2003

[mapesii]

I am kinda new at excel so I might seem a little dumb about this. But I am using Excel 2003 and I have a worksheet with 60 rows and 15 columns. Using form tool I put a checkmark box in every cell. I want to count the total amount of boxes checked at the end of each row. Can this be done. Also is there another way to do this thatt might be easier. My goal was to be able to use only the mouse to select or unselect each box to eliminate using key strokes.

 

[Greg Truby]

Have you linked the checkboxes to cells? If so then let's say you linked them to cells A1 thru A60 then you could just use

• =SUMPRODUCT(--A1:A60)

 

[mapesii]

I have not link cells. Not really sure how to do that

 

[Greg Truby]

Did you use checkboxes from the Controls Toolbox toolbar or from the Forms toolbar?

 

[mapesii]

Forms toolbar

 

[mapesii]

I want to total all check marks in row 1 across 15 columns

 

[Greg Truby]

Forms toolbar

For forms checkboxes right-click and pick format control... off the popup menu (it's the last option) and on the control tab of the dialog box (last tab) you can set the link cell. [In all honesty, I've never understood why anyone would put a checkbox on a worksheet and not link a cell to it - without linking I don't see what's the point of the checkbox?]

Once you have the links set, then you can use the SUMPRODUCT formula I showed you above.

 

[mapesii]

Okay, I will give it a go. Thanks for your help.