Forum Discussion

Ding080's avatar
Ding080
Copper Contributor
Jun 02, 2022
Solved

conditional addition of values

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"

Resources