4 formulas utilizing Countifs, 2 range/crits & a Subtotal counting only current month.

Working on a spreadsheet that requires me to get trainer survey averages...We get our data from an sharepoint export which we cannot filter until it's in excel. It's a lot of data so while it's not a big deal to manually filter, I was hoping to automate the process. What I've been doing is pasting the export into worksheet 2 and displaying the info (survey averages) into worksheet 1.

In for averages I need, I need four different formulas, two "all to date " and two "current month only"
1. Total number of responses to Survey...All to Date subtotal(1, in sheet 2 (named PASTE), filter by all named "Mike" in range L2:L10000...With manual filters have been using =SUBTOTAL(2,PASTE!A1:A10000)
2. Monthly number of responses to Survey...Exactly like above but also include current month only...For now I want June, but I would prefer to use a TODAY so I don't have to change to July next month
3. Total number of response to survey question...All to date subtotal(2, in sheet 2 (named PASTE), filter by all named "Mike" in range L2:L10000...Then need the average number in range C2:C10000, again for only rows that have "Mike" in column L...With manual filters have been using =SUBTOTAL(1,PASTE!C2:C10000)
4. Total number of responses to survey questions for current month only...Same as above but for current month only

Any help would be greatly appreciated.



Column L has the trainers name and that is the first the thing I need "auto" filters.

Thanks, here you go