Forum Discussion

LameloCall's avatar
LameloCall
Copper Contributor
Apr 30, 2022
Solved

Calculating a % based on a Y or N in a column

I am trying to create an excel sheet to track trading data. I have one column that is to designate whether the trade was a win or a loss, so it either has a "W" or an "L" in it. How would I be able to create a formula that would give me a % of Ws out of all the cells in the column with either a "W" or "L" in them?

If it needs to be a number, I can easily switch the "W" to "1" and "L" to "0"

Any help is greatly appreciated. I thought I would use a sumif formula but keep getting an error and can't seem to figure it out, although I feel like this would be rather simple. Thanks in advance.

Resources