SUMIF returning 0

Hi, I am using the sumif function on data that already has formulas within the cells (sum-range) which i think is tripping up the sumif formula and returning zero.   Example.  I am trying to sum de...