Sumifs

%3CLINGO-SUB%20id%3D%22lingo-sub-710130%22%20slang%3D%22en-US%22%3ESumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710130%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Im%20using%20sumif%20to%20calculate%20a%20percentage%20calculation%20if%20a%20cell%20has%20X%20entered%20in%20it.%20So%20if%20B1%20has%20X%20input%2C%20E10%20will%20calculate%2020%25%20from%20the%20sum%20total%20in%20cell%20D10.%20The%20formula%20I%20am%20using%20is%26nbsp%3B%3DSUMIF(B1%2C%22x%22%3DD10*0.2).%20But%20the%20sum%20is%20just%20calculating%200.%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-710130%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-710422%22%20slang%3D%22en-US%22%3ERe%3A%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710422%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363703%22%20target%3D%22_blank%22%3E%40abcwarranty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20criteria%20is%20always%20FALSE%20since%20you%20compare%20text%20%22x%22%20with%20some%20number%2C%20they%20are%20never%20equal.%20Use%20something%20like%3C%2FP%3E%0A%3CPRE%3E%3DIF(B1%3D%22x%22%2C%20D1*0.02%2C0)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-710928%22%20slang%3D%22en-US%22%3ERe%3A%20Sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThanks%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E
abcwarranty
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

@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)

 

 

@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