Forum Discussion
Ding080
Jun 02, 2022Copper Contributor
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"
- OliverScheurichGold Contributor
- Ding080Copper Contributor
Thank you OliverScheurich
- Riny_van_EekelenPlatinum Contributor
- Ding080Copper ContributorMate, Thank you!. I've been watching so many youtube videos. Legend!