Forum Discussion
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 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?
3 Replies
As variant formulae in column J return texts which looks like numbers, not numbers. For example, =LEFT("2a") returns text "2", not number 2. To have the number we may use =1*LEFT("2a")
Perhaps something else, it's hard to say without sample file or at least screenshot.
- Ah amazing that has worked thank you so much I was wracking my brain!
AliceH2265 , you are welcome
