Sumif - criteria problem

[akuku]

Hello!


I have problem with Sumif function. If the criteria is 'equal to' there is no problem as you can see here: http://postimg.org/image/wugze7ast/

But if I change the criteria to 'higher than' the result is just 0, which is wrong. You can see it here http://postimg.org/image/rckapk5yd/

What's wrong with this function?


Thanks in advance!

 

[Colin Legg]

Hi,


The criteria needs to be ">"&B2 instead of ">B2".


The criteria you're using at the moment is a comparison against the word "B2" rather than against the value in the cell B2.