Totaling columns

Hello,
I am making a simple spreadsheet to track external queries. It is set up that when the Submit button is selected on the UserForm, the entries in the boxes from the form will go onto Sheet 1 on the next available row. For some of these columns, I would like to generate totals for all of the entries. For example, there are columns 28/29, 27, Local, NCIC that are generated by checkboxes. I want to count all of the TRUE responses for each and place the result onto a REPORT sheet. I imagine this just involves a countifs formula on the REPORTS sheet.

The tricky part is this...
I would like to generate daily totals for each shift, and each day, and to date for the year on the REPORTS sheet.

Can anyone help with these various formulas? Thank you!!!

By the way, I know I am asking about formulas, but since this is generated by a UserForm, I figured this was the safest place to post this.

Thank you very much! For the last part, I'm actually looking for the Year to Date. My apologies, I wasn't very clear about that. If I could have a Monthly to Date also, that would be great.

That's the thing, it will have many entries for each day....perhaps hundreds, and I would like to be able to also track by month and for the entire year.

I will check it when I'm back at work tomorrow. Thanks! You are always so helpful.

I changed a few things around, but it did exactly what I needed it to. Thank you!!!

Since this part is solved, i am going to post another thread for another aspect of this that I need help with.