Check box formula and summary

My spread sheet has 10 columns, and each text heading has a numeric value as well. There are 12 rows listed, each being a hospital. I have a check box in each row/column and what I would like to do is the following:

1. When the box is checked for a hospital, it means they offer the service represented by the title of the column. Lets say the value attached to that title is 5I want the check box to remain and remember the value.
2. I would like to sum the hidden values both vertically (row 13) and horizonally (row 11) after all boxes have been checked (or not).

Is this possible?? I have attached an abbreviated sample. Thanks for yoiur help.

Thanks for your quick reply. The result is not exactly what I had in mind. I am not looking for a count but a sum total of values. The reason I thought check boxes is because I assumed I would need a formula behind each check box in the first column so that when it was checked, it would recognize a value of 5, and if the check box in the 2nd column check, it would recognize it as the value 4. Then I could do an easy sum at the end of each row and the bottom of each column.

I didn't want the cells all cluttered so I though if I could just use the check box, and not have the corresponding value visible, it would look much better. Can this be done? If so, I am struggling with the formula for the check box.

If there is another way to accomplish this, I am open for suggestions. This has to go to our senior VPs so I am being a bit more particular.

I took your file and modified it a bit, still using the check marks. Here is what you will need to do in order to accomplish this in your full file:

-You need to assign the Link Cell property of each of the check boxes to the cell in which it is located. To do this, right-click on the check box, and select properties. You will see Linked Cell. Next to this, type in the cell reference (i.e. B2). This can be a tedious process if you have a lot of check boxes. However, you could use a quick VBA procedure to assign the linked cell property to all check boxes on the sheet:

Sub ckboxes()
    Dim Cb As OLEObject
    For Each Cb In Sheets("Sheet1").OLEObjects   'change to your sheet name
        If Cb.Name Like "CheckBox*" Then _
            Cb.LinkedCell = Cb.TopLeftCell.Address
    Next Cb
End Sub

-Format the linked cells (the cells behind the check boxes) using a custom format of 3 semi-colons: ;;; This will cause the font to be invisible.

HTH

Jason

That is exactly what I am looking for. You have been a great help. I work a lot with Access but rarely do this type of thing with Excel, so again I am learning.

If I can ask just one other question please. What if you only wanted the Yes to show, and if it is a no it would be blank? Would you still use the drop down but eliminate the no option? I ask this question in the event they want a cleaner look.