sumifs / speech mark question.

[bionicle]

Hi all,
Question for you, why is it that I have to put a 0 betweenthe speech marks to get this formula to return a value?
If I take the “0” out of the speech marks I get nothingback? What am I doing wrong.

=SUMIFS(V5:V2247,T5:T2247,"",X5:X2247,"0",Y5:Y2247,"EME")


Steve

 

[trimmjens]

Re: sumifs / speach mark question.

What kind of values do you have in the X column? 0 and "" is not the same
I tried the formula and it seems to work for me.

If:
T5 = "" (blank)
X5 = 0
Y5 = "EME"
It returns the value of V5