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 department heads.  My formula is =SUMIF($E$2:$E$95,$E$102,J$2:J$95).  E column being department J column being number of heads.  The issue is the J column is already formulated to pull through when a person joined.  If I manually override this column the sum works.

Is there any way around this so that the sumif formula looks for value in the cells rather than the formulas?

​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 department heads.  My formula is =SUMIF($E$2:$E$95,$E$102,J$2:J$95).  E column being department J column being number of heads.  The issue is the J column is already formulated to pull through when a person joined.  If I manually override this column the sum works. Is there any way around this so that the sumif formula looks for value in the cells rather than the formulas?  Read More

​