Forum Discussion

valerie21's avatar
valerie21
Copper Contributor
May 03, 2019

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 ?    
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
May 03, 2019
You can use this formula:
=SUMPRODUCT(B:B*(D:D="x"))
  • valerie21's avatar
    valerie21
    Copper Contributor
    May 03, 2019

    Twifoo

    Thanks you but it's not working :

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 03, 2019

      valerie21 , second multiplier shall be inside SUMPRODUCT

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

       

      • valerie21's avatar
        valerie21
        Copper Contributor
        May 03, 2019

        SergeiBaklan Thabnk you very much it's working now

Resources