• 470K Members
• 6,883 Online
• 568K Conversations

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

Highlighted

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

@valerie21 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies