Jun 20 2019 03:58 AM
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?
Jun 20 2019 04:23 AM
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)