SUMIF formula is not Working

Good morning,

I am working with a file that lists all employees by their job type and position level. I have used the following formulas:


=SUMIF('JOB LOCATION'!$D$8:$D$324,"15AO4",'JOB LOCATION'!$H$8:$H$324)

=SUMIFS('JOB LOCATION'!$H$4:$H$324,'JOB LOCATION'!$D$4:$D$324,"15A*",'JOB LOCATION'!$D$4:$D$324,"*O4")


I want to sum personnel by their position level and the formula count does not match the physical count for the specific job type and I cannot figure out why. The D column lists the job type (15A) and position level (O4) and the H column lists the number of personnel that match those criteria. I have made sure that the H column are numbers vice text. I have made sure that the 'O4' is 'O4' vice '04'. I have attached a sample of one of the 25 worksheets in the file. Any help would be greatly appreciated.

Sorry for the delay in replying. Your suggestions worked perfectly! I had hoped that I had done all the required formatting revisions. Clearly not. Thank you very much for the help. It had been driving me crazy for the previous 2-3 days.