DCOUNT function not working for me on the attached spreadsheet

I have attempted to follow numerous examples of DCOUNT formulas to total the number of instances of each activity type on the attached spreadsheet. I hope to show the totals next to the appropriate labels below the table starting with Row 125. Can anyone help with the syntax? I have an urgent need to use the data on a regular basis and the output will always follow the attached format.

Thank you in advance for any help you can provide.

Mike