conditional addition of values

[Ding080]

Hi all,

I'm trying to add up the amount of two different items in one column if a condition is met in another column.

bit stuck on the command

=sumproduct(B:B="TRADE")/countifs(O:O="W""L")

I only want to count the amount of "W"s and "L"s in a column if the corresponding row in another column says "TRADE"

[#2 · Accepted solution]

@Ding080Try this:

=SUM(COUNTIFS(O:O,{"W","L"},B:B,"TRADE"))

[#3]

Mate, Thank you!. I've been watching so many youtube videos. Legend!

[#4]

@Ding080 

=SUMPRODUCT((B:B="TRADE")*((O:O="W")+(O:O="L")))

An alternative could be SUMPRODUCT. 

[#5]

Thank you @OliverScheurich