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
Highlighted
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
Highlighted
You can use this formula:
=SUMPRODUCT(B:B*(D:D="x"))
Highlighted
Highlighted

@valerie21 , second multiplier shall be inside SUMPRODUCT

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

 

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

Highlighted
Related Conversations
Excel If Functions
Mfouad2255 in Excel on
10 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies