Hi, Im using sumif to calculate a percentage calculation if a cell has X entered in it. So if B1 has X input, E10 will calculate 20% from the sum total in cell D10. The formula I am using is =SUMIF(B1,"x"=D10*0.2). But the sum is just calculating 0. What am I doing wrong?