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
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