Forum Discussion
Sumifs
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(B...
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)
SergeiBaklan Thanks :)
