Sumifs

[abcwarranty]

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?

[#2]

@abcwarranty 

You criteria is always FALSE since you compare text "x" with some number, they are never equal. Use something like

=IF(B1="x", D1*0.02,0)

[#3]

@Sergei Baklan Thanks :)