I am creating a workbook with many lookups and functions but i am currently stuck.

I have 7 sumif functions looking up data from a table the first 5 work as designed but for some reason the last 2 are not working although the cell formats are the same as the other.

Any advice?