How can I make a total of some amounts located in Column B if the lines are marked with "X" in column D ?
Thanks you but it's not working :
@valerie21 , second multiplier shall be inside SUMPRODUCT
=SUMPRODUCT( E2:E23*(G2:G23="X") )
@Sergei Baklan Thabnk you very much it's working now
@valerie21 , you are welcome