New Contributor

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 Replies


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)



@Sergei Baklan Thanks :)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies