SUMIFS Issues

Hi everyone,

I have a rather large data set where I am trying to use sumifs to get the data that meets a set of 6 criteria. In the data set I named all the ranges to make the sumifs easier to understand and work with. The data sheet is on one tab and I am working on a new sheet where I clarify the criterion that must be met.

The problem that I am having is that a number is not getting returned in any of the cells, when I know there is data available, and the one cell that is returning a value is wrong.

Can someone please help me with this issue, explain the problem, pointing me to another thread, helping with the issue, etc? Anything would be greatly appreciated.

I have looked around and not found any post about this similar problem, also I have ensured that calculations are automatic. In the past I have used formulas very similar to this and they have worked in other workbooks for me. The file I'm working with is attached.