Averageif Function in VBA

Hi guys and gals, I'm trying to calculate the average of a column if another column contains certain text, and of course, I need a macro to do this.

Here's what I've got so far:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

My VBA skills are limited to hunting and pecking at this point, so your help is appreciated!

For clarification, I'm trying to spit out the Manager/Supervisor Average in Cell E2 (and then I'll want to spit out the Staff (no direct reports) in E3)

Andy, thanks so much. I see exactly what you did and why it works. Awesome work.