Calculate win rate issue

[MonsterMan]

I’m trying to calculate the number of winning trade on my table. The header of my table is ‘Win / Loss’. Each trade is a ‘Win’ or ‘Loss’. Out of the 3 trades made, all 3 were ‘win’, but win rate is shown at 38%, instead of 100%
This is the formula I’m using: =COUNTIF(Table2[Win / Loss],"Win")/COUNTA(Table2[Win / Loss])

Am I missing something?

Thanks

 

[Eric W]

The formula works OK, but how is the Win / Loss column being populated? If you have spaces in that column, or if the "Win" is a result of a formula, then the COUNTA function won't count the cells properly. Try this:

=COUNTIF(Table2[Win / Loss],"Win")/SUM(COUNTIF(Table2[Win / Loss],{"Win","Loss"}))

 

[Marcelo Branco]

Are there blank cells in column Win / Loss?
If so, see if this works
=COUNTIF(Table2[Win / Loss],"Win")/COUNTIF(Table2[Win / Loss],"?*")

M.

 

[Modesto73]

Is the Win/Loss column blank in the other rows (I assume there are more than 3 rows?). If they contain formulas that return blanks, that will still be counted by the CCOUNTA function.

Ooops.. now redundant since others posted regarding this already.

 

[MonsterMan]

That worked great. Thanks

Are there blank cells in column Win / Loss?
If so, see if this works
=COUNTIF(Table2[Win / Loss],"Win")/COUNTIF(Table2[Win / Loss],"?*")

M.