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 t...
  • Lorenzo's avatar
    Apr 30, 2022

    LameloCall 

     

    in C2:

    =COUNTIF(A2:A10,"w") / COUNTA(A2:A10)

Resources