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

[valerie21]

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 ?

[#2]

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

[#3]

@Twifoo

Thanks you but it's not working :

[#4]

@valerie21 , second multiplier shall be inside SUMPRODUCT

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

[#5]

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

[#6]

@valerie21 , you are welcome