Looking for a sum or count formula

If you make the titles in Column A consistent or add a column in Workforce that categorizes each item in Column A as under the items in Column A of the Job Group sheet.. then you can use formula like this in E6:

=SUMIF('Workforce Analysis'!$A:$A,MID($A6,FIND(" ",$A6)+1,255),'Workforce Analysis'!F:F)

copied down and across the Male section,

Then in M6 use:

=SUMIF('Workforce Analysis'!$A:$A,MID($A6,FIND(" ",$A6)+1,255),'Workforce Analysis'!O:O)

copied down and across Female section.

I wasn't able to get that to work, but I'm sure it's the way I have this set up. This may help: Workforce column D is the same data as Job Group column B so if I make their column headings the same, would that work?