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

@Twifoo

Thanks you but it's not working :

 

@valerie21 , second multiplier shall be inside SUMPRODUCT

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

 

Highlighted

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

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