• 513K Members
• 2,415 Online
• 610K Conversations

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
Highlighted

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