• 414K Members
• 6,349 Online
• 479K Conversations

Highlighted
New Contributor

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

5 Replies

# Re: make total in one column if marked "X" in other column

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

# Re: make total in one column if marked "X" in other column

@Twifoo

Thanks you but it's not working :

# Re: make total in one column if marked "X" in other column

@valerie21 , second multiplier shall be inside SUMPRODUCT

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

# Re: make total in one column if marked "X" in other column

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

# Re: make total in one column if marked "X" in other column

@valerie21 , you are welcome

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies