Adding up check boxes

[aidankdb]

Hi, I could do with some help as I'm not used to Excel. I'm trying a create a time sheet for our employees where they can select drop boxes to show how many days they work. Then all the drop boxes add up to show how many days. Also with a function where they can select a drop box to select all the weekdays in the month. I've attached a document of what I want it to look like. Any help would be appreciated. Thanks

[JieJenn]

Countif? =COUNTIF($A$5:$G$9,"True")

[aidankdb]

Your a star thank you.

[aidankdb]

Thanks for the help. I've attached a copy of what I was advised to do. I also created a select all function. What I need it to do is only select weekdays. Any ideas? Thanks

[JieJenn]

To count weekdays only, change your reference up to column E. =COUNTIF($A$5:$E$9,"True")

[aidankdb]

Thanks, its actually a checkbox when ticked that selects all the week days in the calendar. At the moment i've made to to select every day but not sure how to do just weekdays
This is the code im using to select all the days
"
Sub CheckBox1_Click()

Dim CB As CheckBox
For Each CB In ActiveSheet.CheckBoxes
If CB.Name <> ActiveSheet.CheckBoxes("Check Box 1").Name Then
CB.Value = ActiveSheet.CheckBoxes("Check Box 1").Value
End If
Next CB
End Sub

"

[JieJenn]

Look attached file.

Please Login or Register  to view this content.