Looking for a sum or count formula

I am trying to add up data based on another tab in my workbook using specific criteria. I have attached the file. The first tab lists demographic data by job title, job group,gender and ethnicity, but on then the next tab I need to total it by job group, gender and ethnicity. I was hoping to use a sum or count formula to auto-populate the second tab, but I can't get it to work.

Once the Job Group # column headings were named the same, this solved it:
E6 =SUMIF('Workforce Analysis'!$D:$D,MID($B6,1,255),'Workforce Analysis'!G:G)
M6 =SUMIF('Workforce Analysis'!$D:$D,MID($B6,1,255),'Workforce Analysis'!O:O)