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

Question

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 ?&nbsp;&nbsp;

twifoo · Answer

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

valerie21 · Answer

TwifooThanks you but it's not working :&nbsp;

sergeibaklan · Answer

valerie21&nbsp;, second multiplier shall be inside SUMPRODUCT
=SUMPRODUCT( E2:E23*(G2:G23="X")  )
&nbsp;

valerie21 · Answer

SergeiBaklan&nbsp;Thabnk you very much it's working now

sergeibaklan · Answer

valerie21&nbsp;, you are welcome

Forum Discussion