I want to sum up all the values from B4:B1000 (money) if the cell beside it, C4:C1000 has the letter "W" or "L" in it. I want these in two different cells to count the amount won and amount lost.
I have tried =COUNTIF(C4:C1000,"L") for both L and W but neither work. Please help if you can, it is greatly appreciated! Thank you in advance .
Bookmarks