• 513K Members
• 2,712 Online
• 611K Conversations

Highlighted
New Contributor

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

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

# Re: make total in one column if marked "X" in other column

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

# Re: make total in one column if marked "X" in other column

@Twifoo

Thanks you but it's not working :

# Re: make total in one column if marked "X" in other column

@valerie21 , second multiplier shall be inside SUMPRODUCT

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

# Re: make total in one column if marked "X" in other column

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

# Re: make total in one column if marked "X" in other column

@valerie21 , you are welcome

Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Translation problem on Transifex
Duran Hsieh in Localization Feedback on
2 Replies