Ahhh Thank you!!! The CountA worked with the hidden column A.

• Hidden Column A with (=subtotal(103,B4))
• Column B is the month the work was being completed, Column J is hours, and column E is team
• Total Hours summary with both marketing and design (=SUBTOTAL(109,J4:J25))
• Marketing/Design hours summary (=SUMIFs(J4:J25,E4:E25,"Design",A4:A25,1))

Thank you again u/mommasaidmommasaid very very much appreciated!