Home

make total in one column if marked "X" in other column

%3CLINGO-SUB%20id%3D%22lingo-sub-524188%22%20slang%3D%22en-US%22%3Emake%20total%20in%20one%20column%20if%20marked%20%22X%22%20in%20other%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524188%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EHow%20can%20I%20make%20a%20total%20of%20some%20amounts%20located%20in%20Column%20B%20if%20the%20lines%20are%20marked%20with%20%22X%22%20in%20column%20D%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-524188%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-524296%22%20slang%3D%22en-US%22%3ERe%3A%20make%20total%20in%20one%20column%20if%20marked%20%22X%22%20in%20other%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-524296%22%20slang%3D%22en-US%22%3EYou%20can%20use%20this%20formula%3A%3CBR%20%2F%3E%3DSUMPRODUCT(B%3AB*(D%3AD%3D%22x%22))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-527133%22%20slang%3D%22en-US%22%3ERe%3A%20make%20total%20in%20one%20column%20if%20marked%20%22X%22%20in%20other%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-527133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%3C%2FP%3E%3CP%3EThanks%20you%20but%20it's%20not%20working%20%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-527177%22%20slang%3D%22en-US%22%3ERe%3A%20make%20total%20in%20one%20column%20if%20marked%20%22X%22%20in%20other%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-527177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332784%22%20target%3D%22_blank%22%3E%40valerie21%3C%2FA%3E%26nbsp%3B%2C%20second%20multiplier%20shall%20be%20inside%20SUMPRODUCT%3C%2FP%3E%0A%3CPRE%3E%3DSUMPRODUCT(%20E2%3AE23*(G2%3AG23%3D%22X%22)%20%20)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-528054%22%20slang%3D%22en-US%22%3ERe%3A%20make%20total%20in%20one%20column%20if%20marked%20%22X%22%20in%20other%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528054%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%3BThabnk%20you%20very%20much%20it's%20working%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-528369%22%20slang%3D%22en-US%22%3ERe%3A%20make%20total%20in%20one%20column%20if%20marked%20%22X%22%20in%20other%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528369%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332784%22%20target%3D%22_blank%22%3E%40valerie21%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
valerie21
New Contributor

Hello All,

How can I make a total of some amounts located in Column B if the lines are marked with "X" in column D ?

 

 

5 Replies
You can use this formula:
=SUMPRODUCT(B:B*(D:D="x"))
Highlighted

@Twifoo

Thanks you but it's not working :

 

@valerie21 , second multiplier shall be inside SUMPRODUCT

=SUMPRODUCT( E2:E23*(G2:G23="X")  )

 

@Sergei Baklan Thabnk you very much it's working now

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies